Hi,
  Does anyone have any samples about what I need to capture in SQL Profile
in order to look at the Lock/DeadLock situation?

Thanks
Ed

How to monitor SQL Server 2000 blocking
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

Tracing Deadlocks
http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp


AMB

Show quoteHide quote

In Profiler, look in the 'Locks' event class category for deadlock related
events. Alternatively you can log detailed information about a deadlock into
SQL Server error log using the following command:

DBCC TRACEON(1204, 3605, -1)

These flags stay active untill the SQL Server service is restarted. If you
want them to be in permanently, you will have to add them as trace flags,
using -T parameter, from the Enterprise Manager Server properties dialog
box.
  Does anyone have any samples about what I need to capture in SQL Profile
in order to look at the Lock/DeadLock situation?

Thanks
Ed

3 Questions on db Theory/Design
Upgrade from SQL Server 7.0 to SQL Server 2000
Problems with NOT IN
restoring db without log
difference between inner join and 'where table1.id = table2.id