[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

capturing deadlocks

will sql error logs will not capture any deadlocks (without trace running)- is this right? so, how can we know if any deadlocks occurred yesterday when the systems were slow.. the trace were not running yesterday.. does that mean we can never know if a deadlocked happened yesterday?

is running the trace the only way to find the deadlocks and its details?
0
25112
Asked:
25112
1 Solution
 
Tony303Commented:
Hi,

I have seen this link here where a user has created a sp and has a SQL Agent job that poles the SQL log every 5 mins.

A bit fiddly to set up, but quite clever I think.
Could be of some use to you perhaps.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b9984ce7-5158-4b11-8aeb-3bb19f582818/where-deadlock-details-are-stored-in-sql-server
0
 
25112Author Commented:
thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now