percent_complete tells you how far a running command has come, but only some commands fill it in. This post times eleven commands on SQL Server 2025, shows which ones report real progress and which stay at 0, and adds a way to watch the silent ones.
Parameters of sp_who2: Active, Session ID and the Login Trap
The parameters of sp_who2 are one optional value that can be a session ID, the word active or a login name. This post counts the rows each form returns, shows that the login form does not filter, and explains the errors.
Capture sp_who2 Output Into a Table With INSERT EXEC
To capture sp_who2 output, create a table with matching columns and fill it with INSERT EXEC. This post builds the table, captures the session list three times with a time stamp, and shows the two errors that stop the method.
DMV Version of sp_who2: A Cleaner Session List
A DMV version of sp_who2 returns the same session details from documented views and leaves out the system tasks. This post builds the query, shows why the old spid above 50 filter fails, and stores the result in a temporary table.
Alerting on Long-Running Queries With a SQL Agent Job
Alert on long-running queries with a five-minute SQL Agent job, a deduplicated log, and one Database Mail notice per new request.
SQL Agent Operators and Notifications: Who Gets the Alert
Configure SQL Agent operators, connect jobs and alerts to email notifications, test delivery, and verify notification evidence.
Finding Queries the Application Cancelled With Attention Events
Capture attention events for canceled requests, read event-file XML, compare Query Store aborts, and inspect transaction cleanup.







