Date: Fri, 29 Mar 2024 11:18:59 +0000 (UTC)
Message-ID: <531484073.69941.1711711139642@ip-10-0-1-26.ec2.internal>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_69940_584678937.1711711139640"
------=_Part_69940_584678937.1711711139640
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
Create alert response bundles
Create alert response bundles
SQL Diagnostic Manager allows you to create alert response bundles for re=
lated alerts. The alert response bundle contains individual alert informati=
on for several alerts, summarized and delivered through only one message.=
span>
To create an alert response =
bundle:
- Click >Alert Ac=
tions and Responses in the menu bar.
- Click Add on the Al=
ert Responses tab of the Alert Actions and Responses dialog box.
- Enter a Name for th=
e rule.
- Check the Where all the metr=
ics are in the specified list box condition.
- Enable the Send an email to =
recipient action.
- Click metric in the=
Edit the rule description field, and select related metrics to include in =
the alert response trigger.
- Click the hyperlink text to select s=
pecific conditions for the rule.
- Click OK to finish.=
Alerts compatible with the=
alert response bundles feature
<=
span style=3D"color: rgb(0,0,0);">Jobs
-
- SQL Server Agent Long Running Job (M=
inutes)
- SQL Server Agent Long Running Job (P=
ercent)
- SQL Server Agent Job Completion
- SQL Server Agent Job Failure<=
/li>
- SQL Server Agent Log
Blocking and Deadlocks
-
- Blocked Sessions
- Blocked Sessions Wait Time (Seconds)=
- Deadlock
Size Databases
-
- Data File Autogrow
- Database Full (Percent)
- Database Full (Size)
Size Disks
-
- OS Average Disk Queue Length (Count)=
- OS Average Disk Queue Length Per Dis=
k (Count)
- OS Disk Free Space (Size)
- OS Disk Full (Percent)
- OS Disk Time (Percent)
- OS Disk Time Per Disk (Percent)
Error Log
Availability Group =
Databases
-
- Availability Group Estimated Data Lo=
ss (Seconds)
- Availability Group Estimated Recover=
y time (Seconds)
- Availability Group Log Send Queue Si=
ze (KB)
- Availability Group Preferred Replica=
- Availability Group Redo Queue Size (=
KB)
- Availability Group Redo Rate (KB/sec=
)
- Availability Group Role Change
- Availability Group Synchronization H=
ealth
- Availability Group Synchronization P=
erformance (Seconds)
------=_Part_69940_584678937.1711711139640
Content-Type: application/octet-stream
Content-Transfer-Encoding: base64
Content-Location: file:///C:/9fd60316b0cf34c0d1e17deb487207d7
iVBORw0KGgoAAAANSUhEUgAAABMAAAARCAYAAAA/mJfHAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA
B3RJTUUH5AYIFA4x34cIYwAAAAd0RVh0QXV0aG9yAKmuzEgAAAAMdEVYdERlc2NyaXB0aW9uABMJ
ISMAAAAKdEVYdENvcHlyaWdodACsD8w6AAAADnRFWHRDcmVhdGlvbiB0aW1lADX3DwkAAAAJdEVY
dFNvZnR3YXJlAF1w/zoAAAALdEVYdERpc2NsYWltZXIAt8C0jwAAAAh0RVh0V2FybmluZwDAG+aH
AAAAB3RFWHRTb3VyY2UA9f+D6wAAAAh0RVh0Q29tbWVudAD2zJa/AAAABnRFWHRUaXRsZQCo7tIn
AAABNUlEQVQ4ja3UzUoCcRTG4Z9aLgzUNiVI68TIcMSPQQtm0SW4KnJTmRqBV2IEShFB4SW0qrXD
zD9BKZCR7iHRlk5SiyCE6WM0z/rl4bwcOA6nf+mdGY1zVtDMsTk7IZfLhZyME14N0TEMVF1Mj2Vk
mZOjPKPRiI7R/TFnq+b+3i4rwSCX1zeoug5AOpWcDousrQMwGLwCsK0oHOZyltyfNRNSjAWPh0W/
j3KxwO39HTvZLC+93mRYQpIoFwu43fMAxGMxAoFlev0+V/W6fewTKpKWUwComk5DFwzfTIznLppo
2sO+gyq1Gg+t1m9FrAeIR6NTQZbNpMgG5VLpC2poOqc2IQt2nD8gMwZVqlWa7bYtyIJ5fV6Gpokm
BGfnFxNBAI7xF6RsbhEOhdCEoPX0OBFkwf47H3/dbjmN17bzAAAAAElFTkSuQmCC
------=_Part_69940_584678937.1711711139640--