Versions Compared

Old Version 19

changes.mady.by.user Alejandra Barrientos

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

The alerts are listed by default Ranks as Rank and categories. The default Ranks are classified as follows:

  • Rank 10 = Service High
  • Rank 20 = Resource High
  • Rank 30 = Database High
  • Rank 40 = Process High
  • Rank 50 = Service Low
  • Rank 60 = Resource Low
  • Rank 70 = Database Low
  • Rank 80 = Process Low
  • Rank 90 =Other

Category: Amazon RDS

MetricRank

CPU Credit balance High

100
CPU Credit balance Low100

CPU Credit Usage

100

Disk Queue Depth

100

Read Latency High

100
Read Latency Low

100

Read Throughput

100

Swap Usage

100

Write Latency High

100
Write Latency Low100

Write Throughput

100

Category: Azure DB

MetricRank

Average Data IO Percent High

100

Average Data IO Percent Low

100

Average Log Write Percent High 

100
Average Log Write Percent Low100

Database Average Memory Usage Percent High

100
Database Average Memory Usage Percent Low100

In-Memory Storage Usage Percent High

100

In-Memory Storage Usage Percent Low100

Max Session Percent High

100
Max Session Percent Low100
Max Worker Percent High100

Max Worker Percent Low

100

Service Tier Changes

100

Category: Backup

MetricRank

Days since last backup

40

Category: Databases

MetricRank

Availability Group Estimated Data Loss (Seconds)

20

Availability Group Estimated Recovery time (Seconds)

20

Availability Group Log Send Queue Size (KB)

20

Availability Group Preferred Replica

10

Availability Group Redo Queue Size (KB)

20

Availability Group Redo Rate (KB/sec)

20

Availability Group Role Change

10

Availability Group Synchronization Health

20

Availability Group Synchronization Performance (Seconds)

20

Data File Autogrow

70

Database Full (Percent)

30

Database Full (Size)

30

Database Read/Write Error Occurred

30

Database Status

30

Filegroup Space Full (Percent)

30

Filegroup Space Full (Size)

30

Index Row Hits (Percent)

70

Log File Autogrow

70

Log Full (Percent)

30

Log Full (Size)

30

Longest Running Version Store Transaction (Minutes)

30

Mirror Commit Overhead (Milliseconds)

30

Mirrored Server Role Change

30

Mirroring Oldest Unsent Transactions

30

Mirroring Preferred Configuration

30

Mirroring Status

30

Mirroring Unrestored Log (KB)

30

Mirroring Unsent Log (KB)

30

Mirroring Witness Connection

30

Session Tempdb Space Usage (MB)

80

Table Fragmentation (Percent)

70

Tempdb Contention (ms)

20

Version Store Generation Ratio

30

Version Store Size (MB)

30

Category: DBaaS

MetricRank

Average Data IO Percent High

100

Average Data IO Percent Low

100

Average Log Write Percent High 

100Average Log Write Percent Low100

CPU Credit balance High

100CPU Credit balance Low100

CPU Credit Usage

100

Database Average Memory Usage Percent High

100Database Average Memory Usage Percent Low100

Disk Queue Depth

100

In-Memory Storage Usage Percent High

100

In-Memory Storage Usage Percent Low100Max Session Percent High
100Max Session Percent Low100Max Worker Percent High100

Max Worker Percent Low

100

Read Latency High

100Read Latency Low

100

Read Throughput

100

Service Tier Changes

100

Swap Usage

100

Write Latency High

100Write Latency Low100

Write Throughput

100

Category: Logs

MetricRank

SQL Server Agent Log

40

SQL Server Error Log

40

Category: Operational

MetricRank

CLR Enabled

90

OLE Automation Disabled

90

OS Metrics Collection Status

90

SQL Server Agent XPs Disabled

50

SQL Server Data Used (Percent)

30

SQL Server Log Used (Percent)

30

SQLdm Repository Grooming Timed Out

90

WMI Service Unavailable

50

Category: Queries

MetricRank

Query Monitor Events (Counts)

80

Category: Resources

MetricRank

Average Disk Milliseconds Per Read

20

Average Disk Milliseconds Per Transfer

20

Average Disk Milliseconds Per Write

20

Disk Reads Per Second

60

Disk Transfers Per Second

60

Disk Writes Per Second

60

OS Average Disk Queue Length (Count)

20

OS Average Disk Queue Length Per Disk (Count)

60

OS Disk Free Space (Size)

20

OS Disk Full (Percent)

20

OS Disk Time (Percent)

60

OS Disk Time Per Disk (Percent)

60

OS Memory Usage (Percent)

20

OS Paging (Per Second)

60

OS Privileged Time (Percent)

60

OS Processor Queue Length (Count)

20

OS Processor Time (Percent)

20

OS User Time (Percent)

60

Page Life Expectancy

60

Procedure Cache Hit Ratio

20

SQL Server CPU Usage (Percent)

20

SQL Server Memory Usage (Percent)

20

Category: Services

MetricRank

Cluster Active Node

10

Cluster Failover

10

Distribution Latency (Seconds)

40

DTC Status

10

Full-Text Search Status

50

Last Full-Text Catalog Update (Hours)

50

Latent replication transaction (Count)

40

SQL Server Active Directory Helper Service Status

50

SQL Server Agent Job Completion

80

SQL Server Agent Job Failure

40

SQL Server Agent Long Running Job (Minutes)

80

SQL Server Agent Long Running Job (Percent)

80

SQL Server Agent Status

10

SQL Server Browser Service Status

50

SQL Server Status

10

Unsubscribed Transactions (Count)

40

Unsubscribed Transactions (Seconds)

80

Category: Sessions

MetricRank

Blocked Sessions

40

Blocked Sessions Wait Time (Seconds)

40

Client Computers (Count)

60

Deadlock

80

Oldest Open Transaction (Minutes)

40

Session CPU Time (Seconds)

80

SQL Server Response Time (Milliseconds)

40

User Connections (Percent)

20

Category: Virtualization

Metric

Rank

Host CPU Usage (Percent)

20

Host Memory Swap Detected

20

Host Memory Usage (Percent)

20

Host Power State

20

VM CPU Ready Wait Time (ms)

20

VM CPU Usage (Percent)

20

VM Host Server Change

20

VM Memory Swap Delay Detected

20

VM Memory Usage (Percent)

20

VM Power State

20

VM Reclaimed/Ballooned Memory (KB)

20

VM Resource Configuration Change

20

VM Resource Limits Detected

20



Scroll pdf ignore
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse