THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

Changing PerfMon Counters on SQL2000 vs SQL2005

You might have noticed, if you’re a heavy user of PerfMon, that some counters are exhibiting alterations in behavior between SQL Server 2000 and SQL Server 2005.  For example, I’ve long used the “Transactions/sec” counter to get an idea of how much work a SQL Server is accomplishing.  Now, in SQL Server 2005, certain internal system processes and their transactions which were not counted in the “Transactions/Sec” reading are now tallied.  Consequently, I recommend that you consider looking at “Batch Requests/sec” as a better indicator of how much work is being processed.





Published Monday, October 15, 2007 5:40 AM by KKline
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Uri Dimant said:

Hi Kevin

I have been using Log Flushes/sec counter to see how busy (transactions) my server is. If you compare Batch Requests/sec and Log Flushes/sec  what woud you perefer to count?

October 16, 2007 12:08 AM

KKline said:

Cool recommendation!  I'll look into it 'cuz I'm not really familiar with it (Log Flushes/sec) off the top of my head.  Thanks Uri!  -Kev

October 22, 2007 2:35 PM

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog



Privacy Statement