powershell检测sqlserver数据库死锁，自动解除死锁并邮件通知管理员

检测SQL Server数据库死锁可以使用以下PowerShell脚本：

# 设置数据库连接信息
$server = "localhost"
$dbname = "YourDatabaseName"
$uid = "YourUsername"
$pwd = "YourPassword"

# 获取当前数据库的死锁信息
$deadlocks = Invoke-Sqlcmd -ServerInstance $server -Database $dbname -Username $uid -Password $pwd -Query "SELECT * FROM sys.dm_tran_locks WHERE request_session_id IN (SELECT deadlock victim FROM sys.dm_tran_locks WHERE resource_type = 'LOCK')"

# 如果有死锁，则遍历并解锁
if ($deadlocks)
{
    foreach ($lock in $deadlocks)
    {
        $sql = "KILL " + $lock.request_session_id
        Invoke-Sqlcmd -ServerInstance $server -Database $dbname -Username $uid -Password $pwd -Query $sql
    }

    # 发送邮件通知管理员
    $smtpServer = "YourSMTPServer"
    $smtpPort = 25
    $smtpFrom = "YourEmailAddress"
    $smtpTo = "AdminEmailAddress"
    $smtpSubject = "Deadlock Detected and Resolved"
    $smtpBody = "The following deadlocks were detected and resolved:`n`n" + ($deadlocks | Out-String)

    $smtpMessage = New-Object System.Net.Mail.MailMessage($smtpFrom, $smtpTo, $smtpSubject, $smtpBody)
    $smtpClient = New-Object System.Net.Mail.SmtpClient($smtpServer, $smtpPort)
    $smtpClient.Send($smtpMessage)
}

上述脚本会自动检测数据库中的死锁并解锁，同时发送邮件通知管理员。请注意替换脚本中的数据库连接信息和邮件相关信息以适应您的环境。