CPU - Average CPU Usage alarm
The CPU - Average CPU Usage alarm is active when the average CPU utilization of the server exceeds a threshold. This value is taken over a specific number of background collections. Sustained high CPU utilization can adversely effect the performance of SQL Server and anything else using this server.
CPU - Individual CPU Usage alarm
The Windows CPU - Individual CPU Usage alarm is activated when the average CPU utilization of a single processor exceeds a threshold. This value is taken over a specific number of background collections. Sustained high CPU utilization of a single processor on multiprocessor systems indicates that process threading may not be functioning efficiently.
CPU - Processor Queue Length alarm
The CPU - Processor Queue Length alarm becomes active when the number of Windows threads waiting for CPU resources exceeds a threshold. Sustained high processor queue length is a good indicator that you have a CPU bottleneck.
Windows Custom Counters alarm
The Custom Counters alarm is raised when the values of any of the Windows custom counters you have configured exceed their thresholds or data collection fails.
Disks - Percentage Used / Free Space alarms
This shows the logical disk is filling up or is full.
Disk Queue Length alarm
The Disk Queue Length alarm becomes active when the maximum disk queue length of any disk exceeds a threshold. Sustained high disk queue length is a good indicator that you have a disk subsystem bottleneck, and usually means that I/O times will be degraded.
Disks - Transfer Time alarm
Disk transfer time measures the time it takes in milliseconds to transfer data between disk and memory. The metric includes disk reads and disk writes.
File - Exceeded Set Size alarm
The File Exceeded Set Size alarm becomes active when one of the files you have configured the Diagnostic Server to track exceeds the size threshold you have set.
Memory - Free System Page Table Entries alarm
The Memory - Free System Page Table Entries (PTE) alarm is raised when this performance counter falls below a threshold.
Memory - Percentage Free Virtual Memory alarm
This alarm is activated when the average free virtual memory drops below a threshold.
Memory - Physical Memory Available alarm
The Memory - Physical Memory Available alarm is raised when the available memory drops below a threshold.
Network - Percentage Bandwidth alarm
The average network bandwidth capacity of the specified network card is nearing the limit where it is saturating the network link. This value is taken over a specific number of background collections.
Paging - Disk Activity alarm
This alarm is activated when paging is low, but the average disk activity on a paging file disk is high. This value is taken over a specific number of background collections.
Paging - File Collision alarm
This alarm becomes active when there is more than one paging file on a single physical disk. This can cause performance degradation – especially on IDE disks. IDE disks allow only a single disk operation to be active on the bus at any time.
Services - Service Not Running alarm
The Services - Service Not Running alarm occurs when a Windows service that is set to start automatically is not running.