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.

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.

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.

Fourth is using SQL Profiler. Often an SQL DBA has to act like a detective looking for the reasons an SQL dataset isn't performing as expected.