I am looking to buy some sql server monitoring/troubleshooting tools for servers on multiple sites in multiple countries. I am currently evaluation NetIQ SQL Diagnostics which looks ok but I am having a few probs with it.. Anyway, what (if any) are the standard tool set that people use for proactive monitoring of SQL Server, excluding perfmon,profiler etc. [?]
Insight for SQL is another great tool that comes to my mind. Seehttp://sql-server-performance.com/spotlights.asp for more info. HTH. Gaurav
Check out satyas post on an article about some useful SQL Server tools: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=838] NHO
Using Quest Spotlight for SQL Server since two months. The main advantage for me is that you can see all information on one screen. In case of invesitgating problems Spotlight provides the information i need. Another feature is that you can check the OS witht Spotlight on Windows. Brgds...MipMip
Another great tool too in the scene of monitoring the SQL server. _________ Satya SKJ Moderator SQL-Server-Performance.Com
What kind of problems you have with NetIQ ? Though rarely used, I like NetIQ SQLCheck for it's neat interface.
I think every other third party tool has got its own importance/advantages which are suitable to a specific environment. _________ Satya SKJ Moderator SQL-Server-Performance.Com
Like mipmip, we recently started using spotlight on sql (by quest). We've found it to be a great tool so far (and you can almost get hypnotized watching it). We're still learning and tuning the assorted options, but so far its been really good. The overhead doesnt seem to be high. And all it takes is a quick glance to identify a protential problem. Chris
Has anyone used both Spotlight and Insight that can compare the two? We basically have a large number of SQL servers and need a tool to help us diagnose resource utilization problems. Typically, we log and analyze performance counters to narrow the scope (isolate it to disk, CPU, memory). Then we usually run profiler to capture a data sample, run index tuning against this data to see if any index improvements exist and then pull the most resource intensive queries from the trace using scripts. It is quite a tedious process just to gather all this data before the analysis can even begin. It looks like both Spotlight and Insight can help with the gathering part and maybe even some analysis. Any input would be greatly appreciated.
Hi, After installing spotlight evaluation copy to test my development server, how do I go about using it and helping me ? Anyone who have use it, pls kindly advise and help me how to go about using it. I can install but don't seem any locking/blocking session, it appear for a while, then disappear. Thank you
Please next time open a new post. The last post was on 2003. Spotlight is a real time monitor. Default time to check server is between 20 and 30 seconds, but you can change that. So if you see any lock, when you try to drill locks, is possible there is no lock at all because it was too short. But you can see history and find it. When some counter is red (also you can configure that) for some time, you can find why using drill. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell All postings are provided “AS IS†with no warranties for accuracy.
