sql-server + performance + snippet

A query that measures CPU consumption per SPID over a 30-second window with full SQL text.

A query that reports how long each of a specific application's queries has been executing.

A self-contained script that simulates repeatable deadlocks on demand for testing recovery code.

A query that reports the number of cached pages and buffer pool usage in GB for each database.