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.
From stackoverflow
-
use Event Notification method. it works in 2005 and 2008. it doesn't present any perf problem for detecting deadlocks
0 comments:
Post a Comment