Can anyone recommend a good SQL server Monitoring Tool? One which will provide info on, server space usage, CPU usage , expensive queries run etc.
closed as not constructive by Aaron Bertrand♦, Thomas Stringer, RolandoMySQLDBA, Jon Seigel, Mark Storey-Smith Oct 16 '12 at 22:50
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
I have been using SQL Spy 9.0 - Cost is free I also use Utility Explorer from Microsoft - Cost free
I've voted to close this, because it's essentially a poll question, and there isn't a possible "right answer." You should be evaluating the vendors' offerings to see which product best suits your requirements and budget. Nobody can tell you which product will do that best.
The major vendors you want to investigate are:
- SQL Sentry Performance Advisor
- Quest FogLight / SpotLight
- Confio Ignite
- RedGate SQL Monitor
- Microsoft System Center Operations Manager
- Idera Diagnostic Manager
They all have evaluation versions so you can test them out. In addition to feature sets you'll want to baseline your workloads and check the additional overhead each monitoring solution adds - no monitoring is 100% free.
Disclaimer: I work for SQL Sentry.