The default setting in SQL Server 2005 and later is to keep a trace running all … SQL Server Default TraceRead more
SQL Profiler
Deadlock Basics
Deadlocks in SQL Server can be difficult to avoid completely, but there are some basic rules … Deadlock BasicsRead more