Any good monitoring tool for Sql Server 2000

Hi,

In the market, there are many vendor that provide SQL Server peformance
monitoring tool like Quest Spotlight, Embarcader Performance centre, Idera diagnostic
manager and Teratrax Performance monitor.

I am looking for a good tool that can help to monitor my SQL server 2000
performance, helping to report of any issues and pin-point of any blocking/locking
issues and etc. If it have other feature, it will be a bonus point.

Hence, can any one recommend and advise which tool that they have use and why
they like or don't like.

Thank you

In my experience, a lot of these tools 'look nice' but dont really provide a lot that I couldnt get from profiler and perfmon.<br />This wouldnt be a problem except they are often very expensive.<br /><br />My advice? learn to use perfmon and profiler, you will learn a lot from simply becoming familiar with these tools.<br />Also relying on 3rd party tools without a good understanding of what the stats mean and where they come from is not good<br /><br />Im sure others will disagree and recommend some tools though <img src='/community/emoticons/emotion-1.gif' alt='' /><br /><br />

We have SQL Diagnostic Manager, and like it. It is an expense -- but you have to compare the cost to the cost of people's time spent creating monitoring tools and scripts based on what Chappy describes.<br /><br />For example, SQL DM provides historical performance and growth stats right out of the box, taking only about 30 mins to set up. Those could be had with scripts and tables and jobs, but someone has to sit and build all that stuff <img src='/community/emoticons/emotion-1.gif' alt='' />. Time = $$.

Coefficient from Quest is quite good too, as discussed in another thread. I share chappy's concern about expense and the fact that you can get this stuff yourself using sql tools, profiler & perfmon, but sometimes you get added value from a 3rd party tool.

Hii,
yes sqlDm of idera is really worth it.... it takes care of every parametre which u want to monitor..
all the details wld be specific to days or even hours.. u can make analysis using the results as well , apart frm this one can genrate alerts based on the thresholds one suppleys at the time of configuring.....
Apart frm this u need to be familiar with perfmon...

next2none is what others feel about the maverick