SQL Sentry

% Free Database Disk Space
% Free Space - Disk Per Server
@@SERVERNAME Incorrect Value
AG Database State
AG Database Sync Status
AG Database in Recovery State
AG Message issues - LRD
APS Distribution Skew Exceeds 10%
APS High Memory Utilization Detected
APS Inaccurate Statistics
APS Replicated Table Exceeds 2 GB
APS tempdb Exceeds 1 TB
APS/Azure DW High Request Queue Time Detected
APS/Azure DW Suspended Requests Detected
AWS Timeouts Detected
Advisory Condition Cleared (% Free Space - Disk Per Server)
Advisory Conditions
AlwaysOn Large Log Send Queue
AlwaysOn Secondary Latency
Amazon RDS - % Free Space - Data/Log File(s)
Amazon RDS - % Free Space - Disk
Amazon RDS - High CPU 80%
Amazon RDS - High CPU for Non-SQL Server process
Amazon RDS - High VLF Count
AutoDealershipDemo - SAAS Activity Log
Autogrowth Disabled for Database File
Availability Replicas Hosted on Same Virtual Host
Availability Replicas with Disks in Same Datastore
Azure DW Distribution Skew Exceeds 10%
Azure DW High Memory Utilization Detected
Azure DW Inaccurate Statistics
Azure SQL DB - DTU Limit Changed
Azure SQL DB High Resource Utilization
Azure SQL DB Max Workers Percent High
Azure SQL DB XTP Storage Percent High
Azure SQL Geo-Replication Error
Azure SQL Max Workers Percent High
Azure SQL Server Connectivity Event
Azure SQL Server Operation Failed
Azure SQL Server-Level Event
Azure SQL XTP Storage Percent High
Azure SQL objects impacted on next version upgrade
CCI Partitioning Errors Exist
Check Last backup
Custom Queries
Data Mining Example
Database Backup Diff SLA Breached
Database Backup Diff SLA Breached - with AGs
Database Backup Full SLA Breached
Database Backup Full SLA Breached - with AGs
Database Backup Log SLA Breached
Database Backup Log SLA Breached - with AGs
Database Job Run Status Change
Database Job Status Change
Database State - Changed
Database State - Offline
Database State - Suspect or Emergency
Databases Added/Removed
Extended Buffer Pool PLE
Foreign Memory Access
Forwarded Records
Fragmentation alert
Free Space - Disk % Global
Free Space - Disk % per Server
Free Space - Disk % per Server - PA Counter
Free Space - Disk - % of small disks or GB of large disks - evaluated per Server
HADR - Backup Compression not turned on
HADR_SYNC_COMMIT Waits
Has KB Been Installed
Has Server Name Changed
Hekaton Memory Use
Hekaton Resource Pool use
High Mirroring Send or Redo Queue for Existing Mirroring Setup
High Number of Blocks
High Number of Table Partitions in SentryOne Database
High Rows in In-memory Staging Table
High Rows in In-memory Staging Table
High VLF Count - AG Primary [2012]
High VLF Count - AG Primary [2014]
IBM - CLR State has changed
IBM - CPU Queue Length - Critical
IBM - CPU Queue Length - Warning
IBM - CPU Queue Length - Warning
IBM - Critical Blocked Sessions Count
IBM - Critical CPU Queue Length
IBM - Critical Database Mirroring Log Redo Queue
IBM - Critical Database Mirroring Log Send Queue
IBM - Critical Disk Read Latency
IBM - Critical Disk Write Latency
IBM - Critical Version Store Size
IBM - Disk Queue Length
IBM - Disk Queue Length - Critical
IBM - Disk Queue Length - Warning
IBM - Disk Time Percent - Critical
IBM - Disk Time Percent - Warning
IBM - FullTextSearch Enabled
IBM - OS Paging
IBM - OS Paging (1000)
Instant File Initialization is not Enabled
KPMG - AG Worker Thread Alert
Long History - Backups
Long History - Jobs
Long Running Open Transactions (More Detailed)
Low Thread Count
MSDTC Service Status Change
Memory Dump Found
Mirroring Transaction Delay
MrbMiner Malware Detected
MrbMiner Malware Detected (AWS-RDS)
MrbMiner Malware Detected (Azure-SQL-DB)
MsDtsServer Service Offline
OLE Automation Procedures State has changed
PBM - Cluster Disk Resource Corruption Error Check
Partition with High Number of Rows
Production Databases not in FULL recovery mode
Replication Agents Not Running - Configured for Continuous Transactional
Replication TSQL Distribution Delivery Latency
Replication TSQL Log Reader Latency
Replication is Distributor
Replication is Installed
Resource Semaphore Waits
SECURITY - Check SQL Agent Job Owners
SF - SSIS Service memory overrun (SQL 2017)
SF - SSIS Spooled Buffers (SQL 2017)
SF - TempDB file < 5% Free Space
SF - Tempdb Large Version Store and Generation Rate exceeds Cleanup Rate
SQL Browser Running
SQL Config - Trace Flag 1117
SQL Sentry
SQL Server Agent Service not set to Automatic
SQL Server Service Offline
SQL: List Disabled Agent Jobs
SSAS Blocking Detected
SSAS Formula Engine Query Pool Job Queuing
SSAS High Memory Limit Exceeded
SSAS Low Memory Limit Exceeded
SSAS Memory Cleaner Current Price Above 0
SSAS Storage Engine I/O Job Queuing
SSAS Storage Engine IO Job Queuing
SSAS Storage Engine Processing Pool Job Queuing
SSAS Sustained Cache Evictions
SSAS Sustained Connection Failures
Security - SQL Agent Job State Changed
Security : Database at risk of priviledge escalation attack.
Security: Agent Job not owned by dbo
Security: SQL Server TCP Port Check
Security: SQL Server TCP Port Check V2
Security: Unexpected loaded Modules
SentryOne Database Table With Over 1,000 Partitions
SentryOne Monitoring Service Offline or Not in Use
Server MAXDOP changed
Server Memory Changed
Server is not patched against Spectre/Meltdown vulnerability
Service Stopped
Sleeping Sessions with Old Open Transactions (SPID&DB)
Startup Procedures Found
Stolen Memory > 70% of SQL Memory Usage
Storage - Transaction Log Larger than Data Files
Stored Procedures - Created
Stored Procedures - Modified
Suspect Pages - Active Corrupt Pages
Suspect Pages - High Record Count
Suspect Pages - Increase in Fixed Pages
Tables - Created
Tables - Modified
Tables Approaching Maximum Number of Table Partitions
TempDB - Page Contention
Tempdb Version Store > 15% of TempDB
Total VertiPaq Memory Exceeds VertiPaq Limit
Total VertiPaq Memory Exceeds VertiPaq Limit (SSAS 2012)
Total VertiPaq Memory Exceeds VertiPaq Limit (SSAS 2014)
Total VertiPaq Memory Exceeds VertiPaq Limit (SSAS 2016)
Triggers - Created
User AC - % Free Space - Disk Per Server
User AC - Advisory Condition Cleared (% Free Space - Disk Per Server)
User Database Compatiblity Level Check
VMWare restricted CPU cores
VertiPaq Nonpaged Memory Approaching VertiPaq Limit (SSAS 2012)
VertiPaq Nonpaged Memory Approaching VertiPaq Limit (SSAS 2014)
VertiPaq Nonpaged Memory Approaching VertiPaq Limit (SSAS 2016)
Windows Volume Exhaustion Date Changed
Windows Volume Forecasted Exhaustion Within 90 Days

MSDTC Service Status Change

MSDTC Service Status Change.condition

Uses a WMI Query to check the status of the MSDTC service, if a change has been detected then an alert will fire.