How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server
I frequently need to see rowcounts and execution time for queries while they’re running. Maybe I’m troubleshooting a slow query …
Read Moreon • 1 min read
The problem: by default, the Performance Monitor application in Windows doesn’t remember which counters you like to use.
This can mean a lot of clicking every single time you open perfmon.
Run: perfmon.exe /sys
This makes perfmon remember the counters and configuration that you like to use!
Watch this 2.5 minute video to see how the magic happens:
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.