THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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.

 

Cheers!

 

-Kevin

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

Comments

 

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

(required) 
(required) 
Submit

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, www.sqlpass.org.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement