SQL Server Performance

Any good monitoring tool for Sql Server 2000

Discussion in 'Third Party Tools' started by vladimir_sim, Jul 23, 2006.

  1. vladimir_sim New Member

    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

  2. Chappy New Member

    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 />
  3. merrillaldrich New Member

    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 = $$.
  4. thomas New Member

    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.
  5. dineshasanka Moderator

  6. Anonymous New Member

    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
  7. Luis Martin Moderator

    For on line spotlight (or sql tools) for history Diagnostic Manager.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page