Posted on

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

SQL Server batch mode cartoon - squirrel

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.

One thought on “Perfmon: Batch Requests/sec counts whole batches, not statements

  1. This is such a clarifying example. Thanks Kendra!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.