THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Roller Downloads   Opml View as RSS news feed in XML

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


Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
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) 
(optional)
(required) 
Submit

About KKline

Kevin Kline is Technical Strategy Manager for the SQL Server business unit at Quest Software. Kevin was the original architect and dev manager for many of Quest's SQL Server tools. Prior to Quest, Kevin worked as an enterprise DBA for a variety of large corporations and government agencies.

This Blog

Syndication
©2006-2008 SQLblog.comTM
Brought to you by Peter DeBetta & Adam Machanic
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement