SQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)

on May 8, 2017

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.

Want more perfmon tips for SQL Server?

Check out my YouTube playlist of perfmon tips here.

Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.

The Transactions/sec counter has big blind spots

Want more perfmon tips for SQL Server?

Search

Posts or Comics for Your Inbox?