HomeНаука и техникаRelated VideosMore From: Kendra Little's SQL Workbooks & Dear SQL DBA

Perfmon counter comparison: Databases\Transactions/sec vs SQL Statistics\Batch Requests/sec

16 ratings | 1805 views
Perfmon counters are great for measuring workload, but choosing which counter to baseline can be confusing. Watch a quick 5 minute demo showing that the SQL Statistics\Batch Requests/sec counter sees more of your workload than the Databases(_Total)\Transactions/sec counter does.
Html code for embedding videos on your blog
Text Comments (4)
DashCam Revenge (1 year ago)
Looking at two servers I have. One hast 4k transactions per second and 3k Batch Request per second. The other has 20K Transaction Per second and just 1.5K Batch Request per Second. Which is the busiest server? :)
Claudio G (1 year ago)
Great video ( I like the short format) ! Can transactions/sec be greater than BatchRequests/sec at a given time ?
Claudio G (1 year ago)
Thanks for the answer !
Yay, glad you like it! Yes, transactions/sec can be higher. Let's say I run three insert commands in a single batch. They'll get counted as 3 by transactions/sec (because it counts inserts, whether or not they're wrapped in a transaction), but the batch gets counted as 1 by BatchRequests/sec.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.