Windows SQL Server template
The SQL Server template monitors the integrity and performance of an SQL Server device.
Performance Monitors- WMI Monitor
Contains the following rules:
- SQL Server Monitoring & Performance - Counter(Buffer cache hit ratio) Trigger(<=99)
- SQL Server Monitoring & Performance - Counter(Connection Memory (KB)) Trigger(>=20480)
- SQL Server Monitoring & Performance - Counter(Full Scans/sec) Trigger(>=50)
- SQL Server Monitoring & Performance - Counter(Optimizer Memory (KB)) Trigger(>=10240)
- SQL Server Monitoring & Performance - Counter(Page Splits/sec) Trigger(>=10)
- SQL Server Monitoring & Performance - Counter(SQL Compilations/sec) Trigger(>=5)
- SQL Server Monitoring & Performance - Counter(Stolen Pages) Trigger(>=10000)
- SQL Server Monitoring & Performance - Counter(Table Lock Escalations/sec) Trigger(>=10)
- SQL Server Monitoring & Performance - Counter(User connections) Trigger(>=100)
- SQL Server Monitoring & Performance - Instance(Database) Counter(Number of Deadlocks/sec) Trigger(>1)
- SQL Server Monitoring & Performance - Instance(First Triggered Instance) Counter(Cache Hit Ratio) Trigger (<=75)
- SQL Server Monitoring & Performance - Instance(_Total) Counter(Active Transactions) Trigger(>=10)
- SQL Server Monitoring & Performance - Instance(_Total) Counter(Cache Hit Ratio) Trigger(<=75)
- SQL Server Monitoring & Performance - Instance(_Total) Counter(Percent Log Used) Trigger(>= 75)
- SQL Server Monitoring & Performance - Instance =(_Total) Counter(Transactions/sec) Trigger(>= 25)
NOTE: All actions for each of the above rules within this template are set to a default of sending an alert to the Enterprise Console. You must manually change this setting if you require an alternative action to be taken upon the generation of an alert.