News

The SQL Profiler allows you to select the Deadlock Graph as a traced event. It captures deadlock information in XML format and displays it graphically in the tool.
Using SQL Server Profiler SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.
Then I would select a Profiler template to use and select events that I wish to trace such as Logins, Logouts, Stored Procedures starting, finishing, T-SQL Batches starting etc.