Why Won't PostgreSQL Use My Covering Index?
Dear Postgres, Why won’t you use my covering index?
Lately I’ve been learning to tune queries running against PostgreSQL, and it’s …
Read MoreSQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)
on • 1 min read
Category:
query-performance
Perfmon counters are great for measuring workload, but choosing which counter to baseline can be confusing.
The Transactions/sec counter has big blind spots
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.
RELATED POSTS
