Capturing stored procedure executions with Extended Events: set up a session with module_end, run a sample procedure, and query the captured data.
Large Memory Servers: How SQL Server Scans the Buffer Pool
SQL Server scans the buffer pool during startup, backup, restore and DBCC, and large memory servers feel it most. An extended event records the scans, shows which commands start one and how many tasks each uses. The last sections explain what SQL Server 2022 changed.
Chatty Applications: Finding Many Tiny Queries per Second
Diagnose chatty applications with batch rates, cached executions, bounded session event counts, and measured round trips per user action.
SQL SERVER – List of Trace Events
sys.trace_events lists available SQL trace events rather than only default-trace collection. Readers asked after my creation-date article.
When a Table Was Created: Find It With Metadata and Traces
To find when a table was created, read create_date from sys.tables. This post adds the default trace and an Extended Events session for the question of who created it, and tests what a rename or an ALTER does to the date.
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.
SSMS Command Timeout: What the Execution Time-out Does
The SSMS command timeout is the number of seconds a query window waits before it cancels a batch. This post lists the four places a time-out can come from and reproduces a client time-out with sqlcmd and PowerShell. It also shows how an Extended Events session proves that the client gave up.