Finding Problem Queries with SQL Profiler - Professional SQL Server 2005 Performance Tuning - page 114

Figure 5-14
In your sample test, if you re-arrange the two UPDATE statements that access the database resource
from one connection in the same chronological order as the other connection, the deadlock issue will
be resolved. For more information on resolving deadlocks, see the SQL Server technical bulletin ''How to
resolve a deadlock'' at http://support.microsoft.com/kb/832524 .
Identifying Long-Running Queries Using
SQL Profiler
Many situations require monitoring long-running queries. For example, an existing Service Level
Agreement (SLA) might require that some items need to be measured by query response time. Database
users might complain that some of the queries have inconsistent response time behaviors. Sometimes
queries can execute slowly or cause application time-outs.
SQL Profiler is one of the most valuable graphical user interface (GUI) tools in determining which queries
take the longest time to execute or confirming which specific queries run slowest. SQL Profiler can
monitor query activity as it occurs.
The following simple scenario will walk through the process of identifying long-running queries.