SQL Extended Events Archives - Page 7 of 7 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

A gardener seen from behind shines a narrow torch beam on one rose leaf with a caterpillar, the garden dark around it.

Replacing Profiler Traces With Extended Events

April 10, 2009

SQL Tips and Tricks

SQL Extended Events, SQL Monitoring, SQL Profiler, SQL Server, SQL Trace

Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.

A trail camera on a fence post watches one sheep standing in a narrow gateway while another waits behind it.

The Blocked Process Report

December 8, 2008

SQL Performance

SQL Extended Events, SQL Lock, SQL Monitoring, SQL Server, SQL Server Configuration

The blocked process report shows the waiting session and blocker after a configured threshold, with Extended Events capturing the XML for review.