Post reply

Monitoring SQL Server With Peformance Counters

  • April 6, 2005 at 8:09 am

    #113640

    I am a Loadrunner Performance tester and I typically recommend the default counters.  Are  there any counters that needs be watched that are not on the recommended list published by microsoft.

    Im trying to find a document that will assist me getting more information out of peformance monitoring by choosing critical performance counters.

    Thanks.

     

     

  • April 7, 2005 at 5:26 am

    #551097

    Try these links, you should find all you need to know

    http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

    http://www.extremeexperts.com/sql/articles/SQLCounters.aspx

    They may talk about SQL 7 in some places but the info is still valid for 2000.

  • April 8, 2005 at 7:43 am

    #551487

    For benchmarking,

    I recommend Batch Req/Sec

    Also, look at compilations/sec and batch compilations/sec

    Keep an eye on Avg Disk Queue Length, but not as a sole measure.  In conjunction with other things it becomes clear whether or not you have an IO bottleneck.

    Page Life Expectancy is a good key indicator as to whether you have enough memory. 

    As noted, there are many articles out there.  Key is to know where you THINK you ahve a bottleneck and drill down.  3 major areas are processor, memory and disk.  Determine which one, then search for specific counters for each of those.

  • April 8, 2005 at 8:20 am

    #551526

    I am familiar with standard windows counters but the additional ones critical to SQL Server will help me out alot.

    Thanks for everyones responses.  I have read the documents and this helps alot.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply