Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Deadlock Detection on MS SQL 2008

Is it possible to detect deadlock on SQL 2008 and send out an email alert ?

Tks
0
AXISHK
Asked:
AXISHK
  • 2
  • 2
1 Solution
 
Vadim RappCommented:
Enabling Email Alerts for SQL Server Deadlocks
by Michael K. Campbell in Practical SQL Server
0
 
AXISHKAuthor Commented:
Which window counters can indicate deadlock?
0
 
Vadim RappCommented:
Number of deadlocks / sec, in performance object "Locks".
0
 
AXISHKAuthor Commented:
Tks
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!

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