back to blog index

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 the "Transactions/Sec" reading are not 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

End of Article

You must log on before posting a comment.

If you don't have a username & password, please register now.

 

      1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31       
or

More blogs about technology,
databases, and SQL Server.