Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Can anyone recommend a good SQL server Monitoring Tool? One which will provide info on, server space usage, CPU usage , expensive queries run etc.

share|improve this question

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.

possible duplicate of Recommendations for MS SQL Server monitoring software or service? – Jon Seigel Oct 16 '12 at 16:42

2 Answers 2

up vote 0 down vote accepted

I have been using SQL Spy 9.0 - Cost is free I also use Utility Explorer from Microsoft - Cost free

share|improve this answer
Thanks for those will check them out – davey Oct 17 '12 at 10:03

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:

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.

share|improve this answer
Hi Aaron, at my old job we used Quest PerfMon (whatever the name was prior to Foglight) which supposedly didn't degrade performance like Sql Server Profiler, do these other tools act in a similar manner [to foglight]? If you have experience in any/all of these, are there any metrics you've seen that can show the degradation in performance based on the tool used for monitoring to see how they compare? – ganders Apr 16 at 17:51
SQL Sentry is the only company I know of (and I'll confess, I haven't checked lately) that has actually documented the overhead you should expect to see given typical settings and a benchmark workload (I actually wrote it). You can download the Word document here. Then feel free to ask any of the other vendors if they have published something similar. In any case, they all have trial versions, so you're not going to get a better idea of overhead than installing them and trying with your workload in your environment. – Aaron Bertrand Apr 16 at 18:21

Not the answer you're looking for? Browse other questions tagged or ask your own question.