# ====================================================================================================
# 
# NAME: MonitorDeadlocks.ps1
# 
# AUTHOR: Yan Pan
# DATE  : 10/20/2007
# 
# COMMENT: This script collects the information about threads and resources involved in deadlocks.
# =====================================================================================================

$query = "SELECT * FROM DEADLOCK_GRAPH"
$sqlnamespace = "root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER"
$selections= "LoginSid", "SQLInstance", "IsSystem", "PostTime", "ComputerName", `
"SessionLoginName", "SPID", "StartTime", "TransactionID", "EventSequence", "TextData", "LoginName"

Get-WMIEvent $query $sqlnamespace $selections