CODEWITHSUNDEEP
sql-serversql-server-profiler
Miyagi Coder
Miyagi Coder

Reputation: 5532

SQL Server 2005 - Blocked Process Report

I need to investigate a series of blocks and deadlocks that have been occurring randomly on our SQL 2008 server. I am the main developer on the site and do not have a DBA to lean on...

I am planning on using the Blocked Process Report in 2005 and enabling a trace.

What performace issues can I expect? The DB server is for a website with moderate traffic and I want to minimize the impact the trace will cause.

Upvotes: 1

Views: 655

Answers (1)

Mladen Prajdic
Mladen Prajdic

Reputation: 15677

use Event Notification method. it works in 2005 and 2008. it doesn't present any perf problem for detecting deadlocks

Upvotes: 1

Related Questions