Perfmon: Batch Requests/sec counts whole batches, not statements

Perfmon: Batch Requests/sec counts whole batches, not statements

1 min read
Category: perfmon , sql-server
Perfmon: Batch Requests/sec counts whole batches, not statements 1 min read
Perfmon: Batch Requests/sec counts whole batches, not statements

The name of the “SQL Statistics \ Batch Requests/sec” counter is confusing: exactly what is a request? The request is the WHOLE batch. See a demo of this counter in this quick 5 minute video.

Video Demo

RELATED POSTS

Bad News, DBAs, We Are All Developers Now

Bad News, DBAs, We Are All Developers Now

I sometimes joke that I’m a Junior Developer and a Principal Database Administrator, which is why I have a Staff level title. I’m not sure …

Read More
Adaptive Joins and Memory Grants in SQL Server

Adaptive Joins and Memory Grants in SQL Server

Adaptive joins let the optimizer choose between a Hash Join and a Nested Loop join at runtime, which can be fantastic for performance when row count …

Read More
Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

I see this pattern repeatedly: a “wide” query that returns many columns and less than 100k rows runs slowly. SQL Server gets slow when it …

Read More