SQL Server Monitoring Tools

[renixinq]

I'm looking at various monitoring tools and wanted to see if anyone had suggestions. So far I've played with products SQL Sentry, Red-Gate, Quest and Confio. I'm liking Red-Gate the most in terms of ease of use and what information it provides. Anyone have any suggestions or experiences?

 

[heatlesssun]

I've used the Red Gate tools in the past for many things like schema comparison and migration and they were pretty good at that.

 

[Nenu]

There used to be a program called AppManager that gave you very fine grained control and reporting.
The company that made it was bought up and I dont know what happened to it after that.
May be worth researching.

hmm, seems they are still alive with the original company name:
https://www.netiq.com/products/appmanager/

 

[Weenis]

Riverbed has some badass tools (used to be opnet).

 

[chrisdunngator]

You may want to look at ScienceLogic. They monitor the entire IT stack.... http://www.sciencelogic.com

 

[4saken]

we use http://www.idera.com/productssolutions/sqlserver/sqldiagnosticmanager

configure alerts/thresholds/notifications/sms/email etc.

Pretty much runs the gamut of qdepth/latency/locks/etc.