| Index |
EntityName |
EntityId |
Path |
ClassName |
ClassId |
WorkflowName |
WorkflowDisplayName |
WorkflowType |
WorkflowId |
WorkflowMPName |
Enabled |
GeneratesAlert |
AlertSeverity |
AlertPriority |
Overridden |
Description |
Parameters |
Overrides |
| 1 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.Database.GarbageCollectionState |
[Deprecated] Garbage Collection State (rollup) |
Monitor |
d8df97df-9adf-8116-5a46-484c84c35d6b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a Critical State and raises an alert if the amount of space used by active rows in all Memory-Optimized Data files drops below the Threshold setting, expressed as a percentage of the size of data files. This monitor is a dependency (rollup) monitor.
This monitor is considered to be obsolete in this Management Pack. |
|
|
| 2 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.AutoClose |
Auto Close Configuration |
Monitor |
83848f44-daf7-7322-a622-752d80293347 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Auto Close setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
AutoClose |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
true |
| ExpectedValue |
OFF |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 3 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.AutoCreateStat |
Auto Create Statistics Configuration |
Monitor |
b374db98-f71a-b662-b2c8-91958a7949f0 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Auto Create Statistic setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
AutoCreateStat |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
ON |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 4 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.AutoShrink |
Auto Shrink Configuration |
Monitor |
f512145d-7204-b4a9-13b3-1f90d5ce89b9 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Auto Shrink setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
AutoShrink |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
OFF |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 5 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.AutoUpdateStatAsync |
Auto Update Statistics Async Configuration |
Monitor |
b04f5fca-4e96-8b86-6748-4f36efe3cced |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Auto Update Atatistics Asynchronously setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
AutoUpdateAsyncStat |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
OFF |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 6 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.AutoUpdateSet |
Auto Update Statistics Configuration |
Monitor |
b1e0e4ae-341c-645d-313a-07bb8337fdff |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Auto Update Statistics setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
AutoUpdateSet |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
ON |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 7 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.AutomaticConfiguration |
Automatic Configuration |
Monitor |
71acca28-ddbf-f853-1cbe-4d74872a5527 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This monitor aggregates the health of automatic configuration monitors. |
|
|
| 8 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 9 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 10 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 11 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 12 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 13 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 14 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.AvailabilityState |
Availability |
Monitor |
a6c69968-61aa-a6b9-db6e-83a0da6110ea |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity availability health. |
|
|
| 15 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.HashIndexAvgChainLengthMonitor |
Average length of the row chains in the hash buckets (rollup) |
Monitor |
3c0e6f64-5541-b47c-fa71-92b4b24a5d58 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This monitor checks Hash Index Empty Buckets Count and Average Length of the Row Chains in the SQL Database. This monitor is a dependency (rollup) monitor. |
|
|
| 16 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 17 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 18 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 19 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 20 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 21 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 22 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.ConfigurationState |
Configuration |
Monitor |
4fea8a72-7ed1-7621-c3a3-103ef0e91574 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity configuration health. |
|
|
| 23 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBBackupStatusMonitor |
Database Backup Status |
Monitor |
491888aa-40a6-f058-2368-c8faea4dfc09 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Error |
Normal |
False |
This monitor checks the status of the database backup as reported by Microsoft SQL Server. Note that the monitor ignores Always On databases. Therefore, it is always "green" for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| IntervalSeconds |
86400 |
| SyncTime |
|
| Threshold |
7 |
| TimeoutSeconds |
300 |
|
|
| 24 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DatabaseErrorUserPolicyStateMonitorRollup |
Database Critical Policies (rollup) |
Monitor |
d00ce1c4-9718-10bf-3f1f-439c9e15a071 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering existing health policies in SQL server instances. This monitor is for critical custom user policies. |
|
|
| 25 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor |
Database Extended Health State |
Monitor |
69f0afbb-2ad3-1ab9-5020-fa5c9a159623 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Database Extended Health Aggregate State monitor |
|
|
| 26 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBStatusMonitor |
Database Status |
Monitor |
4c717493-8d9b-3144-75b2-39a13d833eb9 |
Microsoft.SQLServer.2016.Monitoring |
true |
True |
MatchMonitorHealth |
Normal |
False |
This monitor checks the status of the database as reported by Microsoft SQL Server. |
| Name |
Value |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| IntervalSeconds |
3600 |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 27 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DatabaseWarningUserPolicyStateMonitorRollup |
Database Warning Policies (rollup) |
Monitor |
be70eed8-037b-8198-da69-9b2c40f2248b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering existing health policies in SQL server instances. This monitor is for warning custom user policies. |
|
|
| 28 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.DBChaining |
DB Chaining Configuration |
Monitor |
72e0dbfc-6ec1-7d8c-c617-d4b3d71e7b10 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Cross-database Ownership Chaining Enabled setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
DBChaining |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
OFF |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 29 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.Monitoring.DBFileSpaceMonitor |
DB File Free Space Left |
Monitor |
f6d47cab-d6ef-011f-e598-d72d98e28f6f |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a warning when the free space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| IntervalSeconds |
900 |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| Threshold1 |
10 |
| Threshold2 |
20 |
| TimeoutSeconds |
300 |
|
|
| 30 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.Monitoring.DBFileSpaceMonitor |
DB File Free Space Left |
Monitor |
f6d47cab-d6ef-011f-e598-d72d98e28f6f |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a warning when the free space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| IntervalSeconds |
900 |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| Threshold1 |
10 |
| Threshold2 |
20 |
| TimeoutSeconds |
300 |
|
|
| 31 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.DBFileSpaceMonitorRollUp |
DB File Space (rollup) |
Monitor |
9b5584cb-f80d-399f-f1c9-ae39045650a1 |
Microsoft.SQLServer.2016.Monitoring |
true |
True |
MatchMonitorHealth |
Normal |
False |
The monitor oversees the space available in all Filegroups in the database and on related media. The space available on the media hosting files is only included as part of the free space if autogrowth is enabled for at least one file. This monitor is a dependency (rollup) monitor. |
|
|
| 32 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.DBFileSpaceMonitorRollUp |
DB File Space (rollup) |
Monitor |
9b5584cb-f80d-399f-f1c9-ae39045650a1 |
Microsoft.SQLServer.2016.Monitoring |
true |
True |
MatchMonitorHealth |
Normal |
False |
The monitor oversees the space available in all Filegroups in the database and on related media. The space available on the media hosting files is only included as part of the free space if autogrowth is enabled for at least one file. This monitor is a dependency (rollup) monitor. |
|
|
| 33 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.Database.DBFileGroupSpaceMonitor |
DB Filegroup Space |
Monitor |
cb3b493b-52d3-5785-a214-b65256916266 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Monitors the aggregate space health for the Filegroup. |
|
|
| 34 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.Database.DBFileGroupSpaceMonitor |
DB Filegroup Space |
Monitor |
cb3b493b-52d3-5785-a214-b65256916266 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Monitors the aggregate space health for the Filegroup. |
|
|
| 35 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBFileGroupPerfRollup |
DB Filegroup Space (rollup) |
Monitor |
28ab4685-1f69-8a68-34da-cf17b4a54be1 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This dependency monitor rolls up the overall space health from Database Filegroups to the Database. |
|
|
| 36 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBFileStreamFileGroupPerfRollup |
DB FILESTREAM Filegroup Space (rollup) |
Monitor |
e4f95339-e4df-4688-bd2f-2b377f6db7ae |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This dependency monitor rolls up the overall space health from Database FILESTREAM Filegroups to the Database. |
|
|
| 37 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBSizePercentMonitor |
DB Free Space Left |
Monitor |
b3652673-d963-733a-8005-3504f168d1a9 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
MatchMonitorHealth |
High |
False |
Monitors the space available in the database and on the media hosting the database in percentage terms. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. This monitor does not count free space for FILESTREAM and Memory-Optimized Data file groups. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| IntervalSeconds |
900 |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| Threshold1 |
10 |
| Threshold2 |
20 |
| TimeoutSeconds |
300 |
|
|
| 38 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.Monitoring.DBLogFileSpaceMonitor |
DB Log File Free Space Left |
Monitor |
a8f53bef-5987-52a3-84f3-d58b6716c119 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a warning when the free space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| IntervalSeconds |
900 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| Threshold1 |
10 |
| Threshold2 |
20 |
| TimeoutSeconds |
300 |
|
|
| 39 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.Monitoring.DBLogFileSpaceMonitor |
DB Log File Free Space Left |
Monitor |
a8f53bef-5987-52a3-84f3-d58b6716c119 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a warning when the free space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| IntervalSeconds |
900 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| Threshold1 |
10 |
| Threshold2 |
20 |
| TimeoutSeconds |
300 |
|
|
| 40 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBLogFileSpaceMonitor |
DB Log File Space |
Monitor |
201a1129-70c8-a8b1-9447-3143f39c230c |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Monitors the aggregate space health for the log file. |
|
|
| 41 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBLogFileSpaceMonitorRollUp |
DB Log File Space (rollup) |
Monitor |
9b36a4a5-85b0-4605-a291-f47b1c192a65 |
Microsoft.SQLServer.2016.Monitoring |
true |
True |
MatchMonitorHealth |
Normal |
False |
The monitor oversees the space available in all transaction log files in the database and on related media. The space available on the media hosting transaction log files is only included as part of the free space if autogrowth is enabled for at least one transaction log file. This monitor is a dependency (rollup) monitor. |
|
|
| 42 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.Database.DBFileGroupFxPerfRollup |
DB Memory-Optimized Data Filegroup Space (rollup) |
Monitor |
16ade707-3ec0-5d4e-35a3-003b6e6da62b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This dependency monitor rolls up the overall health from Memory-Optimized Data Filegroup to Database. |
|
|
| 43 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBSpaceMonitor |
DB Space |
Monitor |
c4f57338-ab07-9cf5-0e07-0d67aec351f2 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Monitors the aggregate space health for the database. |
|
|
| 44 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBSizePercentageChangeMonitor |
DB Space Percentage Change |
Monitor |
c9eca51a-404c-bdbe-9813-5c297ce3abb1 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
MatchMonitorHealth |
Normal |
False |
Monitors for a significant decrease of database free space over a number of sample periods. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Available Space Total (%) |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| NumSamples |
5 |
| ObjectName |
SQL Database |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| Threshold1 |
25 |
| Threshold2 |
45 |
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='DBFreeSpacePercent']$ |
|
|
| 45 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.LogShippingDestinationMonitor |
Destination Log Shipping |
Monitor |
201aa936-4a95-4050-fe33-05a64cdbf1a1 |
Microsoft.SQLServer.2016.Monitoring |
true |
True |
Error |
Normal |
False |
This monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration.
Note that all Log Shipping is not supported by any edition of SQL Server Express. |
| Name |
Value |
| FirstComputerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| FirstExpression |
System.Xml.XmlElement |
| FirstLogName |
Application |
| SecondComputerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SecondExpression |
System.Xml.XmlElement |
| SecondLogName |
Application |
|
|
| 46 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DiskReadLatencyMonitor |
Disk Read Latency |
Monitor |
f0a4e219-f172-4c43-02c0-7258fd132299 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Error |
Normal |
True |
Disk Read Latency monitor for 2016 databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.
Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| IntervalSeconds |
300 |
| NumSamples |
6 |
| SyncTime |
|
| Threshold |
40 |
| TimeoutSeconds |
200 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
300 |
300 |
| NumSamples |
6 |
6 |
| SyncTime |
|
00:19 |
| Threshold |
40 |
40 |
| TimeoutSeconds |
200 |
200 |
|
| 47 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DiskWriteLatencyMonitor |
Disk Write Latency |
Monitor |
78e0186b-eb2f-e8c8-2ec4-3d4f1afa81b3 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Error |
Normal |
True |
Disk Write Latency monitor for 2016 databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.
Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| IntervalSeconds |
300 |
| NumSamples |
6 |
| SyncTime |
|
| Threshold |
25 |
| TimeoutSeconds |
200 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
300 |
300 |
| NumSamples |
6 |
6 |
| SyncTime |
|
00:19 |
| Threshold |
25 |
25 |
| TimeoutSeconds |
200 |
200 |
|
| 48 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.HashIndexEmptyBucketsCountMonitor |
Empty Bucket percent in the hash index (rollup) |
Monitor |
e461f84e-507c-e7bb-04b7-f43e672d7afb |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This monitor checks Hash Index Empty Buckets Count in the SQL Database. This monitor is a dependency (rollup) monitor. |
|
|
| 49 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 50 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 51 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 52 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 53 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 54 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 55 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.EntityState |
Entity Health |
Monitor |
e3ab86a1-34fa-35b5-b864-da4db993c0f5 |
System.Health.Library |
true |
False |
|
|
False |
Root roll up monitor. |
|
|
| 56 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.ExternalAccessConfiguration |
External Access Configuration |
Monitor |
fb534125-f013-5ed9-a642-1b37d419d229 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Monitors the aggregate external access configuration health for the database. |
|
|
| 57 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.Database.StaleCFPs |
Memory-Optimized Data Stale Checkpoint File Pairs Ratio (rollup) |
Monitor |
2c902890-4956-8f7d-b580-fc791d89cb51 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a warning state and raises an alert when the ratio of stale checkpoint file pairs in Memory-Optimized Data Filegroup is higher than the specified thresholds. This monitor is a dependency (rollup) monitor.
Please note that the alerts are raised only if the corresponding database is reasonably big (300 or more checkpoint files total). |
|
|
| 58 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.ActiveConnections.Collection |
MSSQL 2016: DB Active Connections Count |
Rule |
c0e5ad21-1d6b-2da2-035f-472048bf73bd |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
True |
SQL 2016 Databases Active Connections performance collection rule |
| Name |
Value |
| IntervalSeconds |
900 |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
900 |
900 |
| SyncTime |
|
00:11 |
| TimeoutSeconds |
300 |
300 |
|
| 59 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.ActiveRequests.Collection |
MSSQL 2016: DB Active Requests Count |
Rule |
97cad540-c152-1503-4d05-f28571e61cd2 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
True |
SQL 2016 Databases Active Requests performance collection rule |
| Name |
Value |
| IntervalSeconds |
900 |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
900 |
900 |
| SyncTime |
|
00:13 |
| TimeoutSeconds |
300 |
300 |
|
| 60 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.ActiveSessions.Collection |
MSSQL 2016: DB Active Sessions Count |
Rule |
37dd1778-b00d-7469-d857-d8b9b15351cf |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
True |
SQL 2016 Databases Active Sessions performance collection rule |
| Name |
Value |
| IntervalSeconds |
900 |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
900 |
900 |
| SyncTime |
|
00:15 |
| TimeoutSeconds |
300 |
300 |
|
| 61 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.ActiveTransactionsDB.Collection |
MSSQL 2016: DB Active Transactions Count |
Rule |
6f78a299-a1d0-d6b2-664f-219849aff1f7 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
SQL 2016 Databases Active Transactions performance collection rule |
| Name |
Value |
| AllInstances |
false |
| ComputerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| CounterName |
Active Transactions |
| Frequency |
900 |
| InstanceName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ObjectName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/PerformanceCounterObject$:Databases |
|
|
| 62 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBAllocatedFreeSpaceMB.Collection |
MSSQL 2016: DB Allocated Free Space (MB) |
Rule |
5a57acae-4a78-7733-b5b5-2315e9262454 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
SQL 2016 DB Allocated Free Space (MB) performance collection rule |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| CounterKey |
DBAllocatedFreeSpaceMB |
| CounterName |
DB Allocated Space Unused (MB) |
| IntervalSeconds |
900 |
| TimeoutSeconds |
300 |
|
|
| 63 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBSize.Collection |
MSSQL 2016: DB Allocated Space (MB) |
Rule |
3702eb93-4955-fa2b-9aa0-bc18374397bc |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Collect database allocated size |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Allocated Space (MB) |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL Database |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='DBSizeMB']$ |
|
|
| 64 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBUsedSpaceMB.Collection |
MSSQL 2016: DB Allocated Space Used (MB) |
Rule |
64154ba6-af7d-0f78-0c17-9ecc1811299a |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
SQL 2016 Databases Allocated Space Used (MB) performance collection rule |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| CounterKey |
DBUsedSpaceMB |
| CounterName |
DB Allocated Space Used (MB) |
| IntervalSeconds |
900 |
| TimeoutSeconds |
300 |
|
|
| 65 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DiskReadLatency.Collection |
MSSQL 2016: DB Disk Read Latency (ms) |
Rule |
908592da-6642-8b4b-d54f-37dcebc17f14 |
Microsoft.SQLServer.2016.Monitoring |
false |
False |
|
|
True |
SQL 2016 DB Disk Read Latency (ms) performance collection rule. Gets maximum read disk latency from all logical disk, which host database files.
Note: This rule is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| IntervalSeconds |
900 |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
900 |
900 |
| SyncTime |
|
00:19 |
| TimeoutSeconds |
300 |
300 |
|
| 66 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DiskWriteLatency.Collection |
MSSQL 2016: DB Disk Write Latency (ms) |
Rule |
3eeb609f-92b5-8fe3-f9cc-d75bbc10c3fd |
Microsoft.SQLServer.2016.Monitoring |
false |
False |
|
|
True |
SQL 2016 DB Disk Write Latency (ms) performance collection rule. Gets maximum Write disk latency from all logical disk, which host database files.
Note: This rule is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| IntervalSeconds |
900 |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
| ParameterName |
DefaultValue |
EffectiveValue |
| IntervalSeconds |
900 |
900 |
| SyncTime |
|
00:19 |
| TimeoutSeconds |
300 |
300 |
|
| 67 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.FileAllocatedSpaceLeftPercent.Collection |
MSSQL 2016: DB File Allocated Free Space (%) |
Rule |
959a93a1-6919-2838-5187-bef772db8997 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in percentage terms. Does not include space left on media hosting a file with autogrowth enabled |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Allocated Space Unused (%) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowPercent']$ |
|
|
| 68 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.FileAllocatedSpaceLeftPercent.Collection |
MSSQL 2016: DB File Allocated Free Space (%) |
Rule |
959a93a1-6919-2838-5187-bef772db8997 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in percentage terms. Does not include space left on media hosting a file with autogrowth enabled |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Allocated Space Unused (%) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowPercent']$ |
|
|
| 69 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.FileAllocatedSpaceLeftMB.Collection |
MSSQL 2016: DB File Allocated Free Space (MB) |
Rule |
8d4ad3a3-11ce-3b9d-2a0c-a2bbbc826e53 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in megabytes. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Allocated Space Unused (MB) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowMB']$ |
|
|
| 70 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.FileAllocatedSpaceLeftMB.Collection |
MSSQL 2016: DB File Allocated Free Space (MB) |
Rule |
8d4ad3a3-11ce-3b9d-2a0c-a2bbbc826e53 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in megabytes. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Allocated Space Unused (MB) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowMB']$ |
|
|
| 71 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.SpaceFreePercent.Collection |
MSSQL 2016: DB File Free Space Total (%) |
Rule |
a51ef11a-3ffd-4e75-9208-357f5229f2c3 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in percentage terms. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Available Space Total (%) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpacePercent']$ |
|
|
| 72 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.SpaceFreePercent.Collection |
MSSQL 2016: DB File Free Space Total (%) |
Rule |
a51ef11a-3ffd-4e75-9208-357f5229f2c3 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in percentage terms. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Available Space Total (%) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpacePercent']$ |
|
|
| 73 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.SpaceFreeMegabytes.Collection |
MSSQL 2016: DB File Free Space Total (MB) |
Rule |
6dba51b8-2b92-c5eb-95f4-86c537b8471d |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in megabytes. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Available Space Total (MB) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceMB']$ |
|
|
| 74 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
Microsoft.SQLServer.2016.DBFile |
6513d93a-77e6-c622-70d9-e547c6f8bfdb |
Microsoft.SQLServer.2016.DBFile.SpaceFreeMegabytes.Collection |
MSSQL 2016: DB File Free Space Total (MB) |
Rule |
6dba51b8-2b92-c5eb-95f4-86c537b8471d |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in a file in megabytes. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Available Space Total (MB) |
| DatabaseName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
1 |
| ObjectName |
SQL DB File |
| ServerName |
$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
0 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceMB']$ |
|
|
| 75 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection |
MSSQL 2016: DB Filegroup Allocated Free Space (%) |
Rule |
86898915-61a0-051d-a4bc-8a67ece8214d |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all files for this Filegroup in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Allocated Space Unused (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowPercent']$ |
|
|
| 76 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection |
MSSQL 2016: DB Filegroup Allocated Free Space (%) |
Rule |
86898915-61a0-051d-a4bc-8a67ece8214d |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all files for this Filegroup in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Allocated Space Unused (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowPercent']$ |
|
|
| 77 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.FileGroupAllocatedSpaceLeftMB.Collection |
MSSQL 2016: DB Filegroup Allocated Free Space (MB) |
Rule |
6579db27-c59e-411e-f57a-fe91b4c164a6 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all files for this Filegroup in megabytes. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Allocated Space Unused (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowMB']$ |
|
|
| 78 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.FileGroupAllocatedSpaceLeftMB.Collection |
MSSQL 2016: DB Filegroup Allocated Free Space (MB) |
Rule |
6579db27-c59e-411e-f57a-fe91b4c164a6 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all files for this Filegroup in megabytes. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Allocated Space Unused (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowMB']$ |
|
|
| 79 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.SpaceFreePercent.Collection |
MSSQL 2016: DB Filegroup Free Space Total (%) |
Rule |
1f0de9c5-c59b-acc6-59cb-619aed7db015 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Collects free database Filegroup space in percentage terms. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Available Space Total (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpacePercent']$ |
|
|
| 80 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.SpaceFreePercent.Collection |
MSSQL 2016: DB Filegroup Free Space Total (%) |
Rule |
1f0de9c5-c59b-acc6-59cb-619aed7db015 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Collects free database Filegroup space in percentage terms. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Available Space Total (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpacePercent']$ |
|
|
| 81 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.SpaceFreeMegabytes.Collection |
MSSQL 2016: DB Filegroup Free Space Total (MB) |
Rule |
aa5b6697-701d-dd80-486c-d2774e085834 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all files for this Filegroup in megabytes. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Available Space Total (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpaceMB']$ |
|
|
| 82 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBFileGroup |
b72a7652-eb7f-9946-53ce-0b43a7ba0796 |
Microsoft.SQLServer.2016.DBFileGroup.SpaceFreeMegabytes.Collection |
MSSQL 2016: DB Filegroup Free Space Total (MB) |
Rule |
aa5b6697-701d-dd80-486c-d2774e085834 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all files for this Filegroup in megabytes. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB File Group Available Space Total (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileGroupId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBFileGroup"]/GroupID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL DB File Group |
| ScriptDelayMsec |
0 |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='FreeSpaceMB']$ |
|
|
| 83 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBDiskFreeSpaceMB.Collection |
MSSQL 2016: DB Free Outer Space (MB) |
Rule |
e96f4c0a-d8d9-060c-38e1-59e2d3f65bde |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
SQL 2016 Databases Free Outer Space (MB) performance collection rule |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| CounterKey |
DBDiskFreeSpaceMB |
| CounterName |
DB Available Outer Space (MB) |
| IntervalSeconds |
900 |
| TimeoutSeconds |
300 |
|
|
| 84 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBSpaceFreePercent.Collection |
MSSQL 2016: DB Free Space Total (%) |
Rule |
64460aca-9f46-c9af-9a41-35a3274db743 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in the database for all files in all Filegroups for this database in percentage terms. Also includes space left on media hosting a file with autogrowth enabled.
Please note that this rule collects metrics for ROWS data only. Metrics for FILESTREAM and for Memory-Optimized Data are ignored. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Available Space Total (%) |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL Database |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='DBFreeSpacePercent']$ |
|
|
| 85 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.DBSpaceFree.Collection |
MSSQL 2016: DB Free Space Total (MB) |
Rule |
ae9929ae-0566-41f3-1f4a-88de3d935c00 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in the database for all files in all Filegroups for this database in megabytes. Also includes space left on media hosting a file with autogrowth enabled.
Please note that this rule collects metrics for ROWS data only. Metrics for FILESTREAM and Memory-Optimized Data are ignored. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Available Space Total (MB) |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| ObjectName |
SQL Database |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='DBFreeSpaceMB']$ |
|
|
| 86 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.FileAllocatedSpaceLeftPercent.Collection |
MSSQL 2016: DB Log File Allocated Free Space (%) |
Rule |
a57a5e36-a826-18db-9973-9f25ab53a951 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Allocated Space Unused (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowPercent']$ |
|
|
| 87 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.FileAllocatedSpaceLeftPercent.Collection |
MSSQL 2016: DB Log File Allocated Free Space (%) |
Rule |
a57a5e36-a826-18db-9973-9f25ab53a951 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Allocated Space Unused (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowPercent']$ |
|
|
| 88 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.FileAllocatedSpaceLeftMB.Collection |
MSSQL 2016: DB Log File Allocated Free Space (MB) |
Rule |
27947f49-702f-b1f4-7224-d4d36b5cdddf |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in megabytes. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Allocated Space Unused (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowMB']$ |
|
|
| 89 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.FileAllocatedSpaceLeftMB.Collection |
MSSQL 2016: DB Log File Allocated Free Space (MB) |
Rule |
27947f49-702f-b1f4-7224-d4d36b5cdddf |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in megabytes. Does not include space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Allocated Space Unused (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceAutoGrowMB']$ |
|
|
| 90 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.SpaceFreePercent.Collection |
MSSQL 2016: DB Log File Free Space Total (%) |
Rule |
c2c59dd2-139b-1413-62d6-a7de1ea06b4b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in percentage terms. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Available Space Total (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpacePercent']$ |
|
|
| 91 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.SpaceFreePercent.Collection |
MSSQL 2016: DB Log File Free Space Total (%) |
Rule |
c2c59dd2-139b-1413-62d6-a7de1ea06b4b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in percentage terms. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Available Space Total (%) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpacePercent']$ |
|
|
| 92 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.SpaceFreeMegabytes.Collection |
MSSQL 2016: DB Log File Free Space Total (MB) |
Rule |
7aae56a4-8014-75cf-1ec0-f39d09d6d85b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in megabytes. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Available Space Total (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceMB']$ |
|
|
| 93 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.DBLogFile |
27f25e1c-ccdd-931a-c9c1-869f07488d4a |
Microsoft.SQLServer.2016.DBLogFile.SpaceFreeMegabytes.Collection |
MSSQL 2016: DB Log File Free Space Total (MB) |
Rule |
7aae56a4-8014-75cf-1ec0-f39d09d6d85b |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The amount of space left in all log files for this database in megabytes. Also includes space left on media hosting a file with autogrowth enabled. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
DB Log File Available Space Total (MB) |
| DatabaseName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| DBFileId |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.File"]/FileID$ |
| InstanceName |
|
| IntervalSeconds |
900 |
| MaximumSampleSeparation |
4 |
| ObjectName |
SQL DB Log File |
| ServerName |
$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Tolerance |
10 |
| ToleranceType |
Absolute |
| Value |
$Data/Property[@Name='FreeSpaceMB']$ |
|
|
| 94 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercent.Collection |
MSSQL 2016: DB Transaction Log Free Space Total (%) |
Rule |
e817e52b-eb7a-9f61-7c8c-62bb104ff553 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Collect unused transaction log space reported by SQL Server as a percentage of total transaction log space |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| CounterName |
Log Free Space (%) |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| InstanceName |
$Data/Property[@Name='Database']$ |
| IntervalSeconds |
900 |
| ObjectName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/PerformanceCounterObject$:TransactionLog |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
| Value |
$Data/Property[@Name='DBLogFreeSpacePercent']$ |
|
|
| 95 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.TransactionsPerSecDB.Collection |
MSSQL 2016: DB Transactions Per Second Count |
Rule |
02df9067-51ee-1034-bbee-e9a7ffa90f83 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
SQL 2016 Databases Transactions per second performance collection rule |
| Name |
Value |
| AllInstances |
false |
| ComputerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| CounterName |
Transactions/sec |
| Frequency |
900 |
| InstanceName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ObjectName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/PerformanceCounterObject$:Databases |
|
|
| 96 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.TornPageDetection |
Page Verify Configuration |
Monitor |
114dd690-98be-826c-f499-041930bb99cc |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Page Verify setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
PageVerify |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
CHECKSUM |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 97 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 98 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 99 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 100 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 101 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 102 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 103 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.PerformanceState |
Performance |
Monitor |
7db3eece-fd0d-fddd-3af7-f8371a914874 |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity performance health. |
|
|
| 104 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.RecoveryConfiguration |
Recovery Configuration |
Monitor |
0f209c1d-128a-ff3d-dcfb-c7b2c8a898d4 |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
Monitors the aggregate recovery configuration health for the database. |
|
|
| 105 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.RecoveryModel |
Recovery Model Configuration |
Monitor |
f27aed61-011f-fe3e-55dc-f327ae2028f5 |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Recovery model setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
RecoveryModel |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
FULL |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 106 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.Database.MemoryConsumptionRollUp |
Resources Pool Memory Consumption (rollup) |
Monitor |
f94097dc-9b87-bcf3-eea9-46dd1762a44d |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
The monitor reports a critical state and raises an alert when the amount of memory used by the resource pool is greater than the Threshold setting, expressed as a percentage of memory available for Memory-Optimized Data tables for the given resource pool. This monitor is a dependency (rollup) monitor. |
|
|
| 107 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 108 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 109 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 110 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 111 |
MOM_LOG |
e7148bf8-c622-9d36-3cfa-86af9a2875c1 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 112 |
MOM_DATA |
c6caebbb-fd6c-2b6c-6821-eb033cce4759 |
DB01.CONTOSO.COM;MSSQLSERVER;OperationsManager;1 |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 113 |
PRIMARY |
e4c443ee-8f2b-7e06-d899-8e4a3ac986c8 |
DB01.CONTOSO.COM;MSSQLSERVER |
System.Entity |
55270a70-ac47-c853-c617-236b0cff9b4c |
System.Health.SecurityState |
Security |
Monitor |
c4192440-55eb-398e-f931-d3fd31ca33bf |
System.Health.Library |
true |
False |
|
|
False |
Roll up monitor that aggregates entity security health. |
|
|
| 114 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.LogShippingSourceMonitor |
Source Log Shipping |
Monitor |
3b4b09bb-2d2d-d886-ac35-c2688d8d6c7f |
Microsoft.SQLServer.2016.Monitoring |
true |
True |
Error |
Normal |
False |
This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration.
Note that all Log Shipping is not supported by any edition of SQL Server Express. |
| Name |
Value |
| FirstComputerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| FirstExpression |
System.Xml.XmlElement |
| FirstLogName |
Application |
| SecondComputerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SecondExpression |
System.Xml.XmlElement |
| SecondLogName |
Application |
|
|
| 115 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.ServiceMonitor |
SQL Server Windows Service |
Monitor |
517e888b-3a4c-d337-b3d1-bbc23ea6ffbb |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This monitor checks the status of the SQL Database Engine service. |
| Name |
Value |
| Frequency |
60 |
| ServiceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ServiceName$ |
|
|
| 116 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
DBBackupMonitor20XX.SQL2016.FullLastBackup.Monitor |
SQL2016 Full Last Backup Monitor |
Monitor |
b9070398-b5c2-d214-1bce-fc385a52950d |
DBBackupMonitor20XX |
false |
True |
MatchMonitorHealth |
Normal |
False |
Description for the new unit monitor.. |
| Name |
Value |
| BagType |
multi |
| CD_CriticalExpression |
System.Xml.XmlElement |
| CD_HealthyExpression |
System.Xml.XmlElement |
| CD_InstanceFilterExpression |
System.Xml.XmlElement |
| CD_WarningExpression |
System.Xml.XmlElement |
| ConnectDBName |
|
| ConnectionString |
$Target/Host/Property[Type="MSQL2016D!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| InstanceName |
|
| IntervalSeconds |
14400 |
| MatchCount |
0 |
| MetricName |
HoursSinceBackup |
| MetricUnits |
Hours |
| ProbeActionTimeoutSeconds |
300 |
| RetryQueryCount |
1 |
| SampleCount |
0 |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SQLCMD |
/**-- Script to capture backup types with last backup taken in X hours.
-- Using DMV : sys.dm_hadr_database_replica_states to identify primary replica - 2014 or later
-- 05/26/2020 -Prem/Tyson - Combined Logic to capture output for backup types (Full, Differential and TLog)
-- -Ignore Read_only databases for monitoring
-- -Script tested versions are 2014, 2016, 2017 and SQL 2019 **/
DECLARE @BACKUP_MON TABLE
(
ServerName nvarchar(128),
SQLInstanceName nvarchar(100),
DatabaseName nvarchar(100),
BackupType varchar(50) ,
HoursSinceBackup bigint
);
WITH Backup_FULL_CTE (FULServerName, FULLSQLInstanceName, FULLDatabaseName, FULLBackupType, FULLHoursSinceBackup)
AS
(SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'D' THEN 'FULL'
WHEN B.TYPE = 'I' THEN 'DIFF'
WHEN B.TYPE IS NULL THEN 'FULL not taken'
END AS [b.Database Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica = 1
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'tempdb'
AND (b.[type] IN ('D', 'I') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type
UNION ALL
SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'D' THEN 'FULL'
WHEN B.TYPE = 'I' THEN 'DIFF'
WHEN B.TYPE IS NULL THEN 'FULL not taken'
END AS [b.Database Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica is NULL
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'tempdb'
AND (b.[type] IN ('D', 'I') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type ),
--- WITH DMV
-- sys.dm_hadr_database_replica_states 2014 or LATER
Backup_TLOG_CTE (TLogServerName, TLogSQLInstanceName, TLogDatabaseName, TLogBackupType, TLogHoursSinceBackup)
AS
(SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'L' THEN 'TLOG'
WHEN B.TYPE IS NULL THEN 'TLOG not taken'
END AS [Backup Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica = 1
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'model'
AND d.recovery_model = 1
AND (b.[type] IN ('L') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type
UNION ALL
SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'L' THEN 'TLOG'
WHEN B.TYPE IS NULL THEN 'TLOG not taken'
END AS [Backup Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica is NULL
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'model'
AND d.recovery_model = 1
AND (b.[type] IN ('L') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type)
INSERT @BACKUP_MON
SELECT * FROM Backup_FULL_CTE
UNION ALL
SELECT * FROM Backup_TLOG_CTE
IF EXISTS (SELECT * FROM @BACKUP_MON )
BEGIN
SELECT * FROM @BACKUP_MON WHERE HoursSinceBackup is NOT null ORDER BY BackupType
END
ELSE
BEGIN
SELECT '0' as ServerName, '0' AS SQLInstanceName,'0' as DatabaseName,'0' As BackupType,'0' as HoursSinceBackup
END
|
| SQLCMDTimeoutSeconds |
30 |
| SyncTime |
|
| ThresholdHighCritical |
55 |
| ThresholdHighWarning |
31 |
| ThresholdLowCritical |
-1 |
| ThresholdLowWarning |
-1 |
| UniqueItemName |
DatabaseName |
| WorkflowName |
DBBackupMonitor20XX.SQL2016.FullLastBackup.Monitor |
| WriteToEventLog |
false |
|
|
| 117 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
DBBackupMonitor20XX.SQL2016.LogfileLastBackup.Monitor |
SQL2016 Logfile Last Backup Monitor |
Monitor |
b4ef420c-7852-f5a4-23ed-18057df256ad |
DBBackupMonitor20XX |
false |
True |
MatchMonitorHealth |
Normal |
False |
Description for the new unit monitor.. |
| Name |
Value |
| BagType |
multi |
| CD_CriticalExpression |
System.Xml.XmlElement |
| CD_HealthyExpression |
System.Xml.XmlElement |
| CD_InstanceFilterExpression |
System.Xml.XmlElement |
| CD_WarningExpression |
System.Xml.XmlElement |
| ConnectDBName |
|
| ConnectionString |
$Target/Host/Property[Type="MSQL2016D!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| InstanceName |
|
| IntervalSeconds |
14400 |
| MatchCount |
0 |
| MetricName |
HoursSinceBackup |
| MetricUnits |
Hours |
| ProbeActionTimeoutSeconds |
300 |
| RetryQueryCount |
1 |
| SampleCount |
0 |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SQLCMD |
/**-- Script to capture backup types with last backup taken in X hours.
-- Using DMV : sys.dm_hadr_database_replica_states to identify primary replica - 2014 or later
-- 05/26/2020 -Prem/Tyson - Combined Logic to capture output for backup types (Full, Differential and TLog)
-- -Ignore Read_only databases for monitoring
-- -Script tested versions are 2014, 2016, 2017 and SQL 2019 **/
DECLARE @BACKUP_MON TABLE
(
ServerName nvarchar(128),
SQLInstanceName nvarchar(100),
DatabaseName nvarchar(100),
BackupType varchar(50) ,
HoursSinceBackup bigint
);
WITH Backup_FULL_CTE (FULServerName, FULLSQLInstanceName, FULLDatabaseName, FULLBackupType, FULLHoursSinceBackup)
AS
(SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'D' THEN 'FULL'
WHEN B.TYPE = 'I' THEN 'DIFF'
WHEN B.TYPE IS NULL THEN 'FULL not taken'
END AS [b.Database Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica = 1
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'tempdb'
AND (b.[type] IN ('D', 'I') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type
UNION ALL
SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'D' THEN 'FULL'
WHEN B.TYPE = 'I' THEN 'DIFF'
WHEN B.TYPE IS NULL THEN 'FULL not taken'
END AS [b.Database Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica is NULL
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'tempdb'
AND (b.[type] IN ('D', 'I') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type ),
--- WITH DMV
-- sys.dm_hadr_database_replica_states 2014 or LATER
Backup_TLOG_CTE (TLogServerName, TLogSQLInstanceName, TLogDatabaseName, TLogBackupType, TLogHoursSinceBackup)
AS
(SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'L' THEN 'TLOG'
WHEN B.TYPE IS NULL THEN 'TLOG not taken'
END AS [Backup Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica = 1
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'model'
AND d.recovery_model = 1
AND (b.[type] IN ('L') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type
UNION ALL
SELECT
cast(SERVERPROPERTY ('ComputerNamePhysicalNetBIOS') as nvarchar(128)) as [ServerName],
@@ServerName as [SQLInstanceName],
d.name as [DatabaseName],
CASE
WHEN B.TYPE = 'L' THEN 'TLOG'
WHEN B.TYPE IS NULL THEN 'TLOG not taken'
END AS [Backup Type],
DATEDIFF(HOUR, COALESCE(MAX(b.backup_finish_date), d.create_date), GETDATE()) AS [HoursSinceBackup]
FROM sys.databases d
LEFT OUTER JOIN sys.dm_hadr_database_replica_states agdb
on agdb.database_id = d.database_id
LEFT OUTER JOIN msdb.dbo.backupset b
ON d.name = b.database_name
WHERE
d.is_in_standby = 0
and is_read_only = 0
AND source_database_id is null
AND agdb.is_primary_replica is NULL
AND convert(varchar(20),databasepropertyex(D.name, 'Status')) = 'ONLINE'
AND d.name <> 'model'
AND d.recovery_model = 1
AND (b.[type] IN ('L') OR b.[type] IS NULL)
GROUP BY
d.name, d.create_date, b.type)
INSERT @BACKUP_MON
SELECT * FROM Backup_FULL_CTE
UNION ALL
SELECT * FROM Backup_TLOG_CTE
IF EXISTS (SELECT * FROM @BACKUP_MON )
BEGIN
SELECT * FROM @BACKUP_MON WHERE HoursSinceBackup is NOT null ORDER BY BackupType
END
ELSE
BEGIN
SELECT '0' as ServerName, '0' AS SQLInstanceName,'0' as DatabaseName,'0' As BackupType,'0' as HoursSinceBackup
END
|
| SQLCMDTimeoutSeconds |
30 |
| SyncTime |
|
| ThresholdHighCritical |
31 |
| ThresholdHighWarning |
24 |
| ThresholdLowCritical |
-1 |
| ThresholdLowWarning |
-1 |
| UniqueItemName |
DatabaseName |
| WorkflowName |
DBBackupMonitor20XX.SQL2016.LogfileLastBackup.Monitor |
| WriteToEventLog |
false |
|
|
| 118 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercentMonitor |
Transaction Log Free Space (%) |
Monitor |
918d74b5-f7ae-11dc-4483-60045131119f |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Error |
Normal |
False |
Transaction Log Free Space (%) monitor for 2016 databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| AzureMaxFileSizeMB |
1048576 |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| IntervalSeconds |
300 |
| NumSamples |
6 |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SqlInstanceName |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$ |
| Threshold |
10 |
| TimeoutSeconds |
180 |
|
|
| 119 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.Database.Configuration.TrustWorthy |
Trustworthy Configuration |
Monitor |
fff3f041-7734-fbbf-e813-46bdaf18c8ce |
Microsoft.SQLServer.2016.Monitoring |
false |
True |
Warning |
Normal |
False |
Monitors the Trustworthy setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
| Name |
Value |
| ConfigValue |
TrustWorthy |
| ConnectionString |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| DatabaseName |
$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$ |
| ExcludeOnExpress |
false |
| ExpectedValue |
OFF |
| IntervalSeconds |
43200 |
| SQLSKU |
$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/Edition$ |
| SyncTime |
|
| TimeoutSeconds |
300 |
|
|
| 120 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
WF.SQL.EDM.AOAG.Latency.Monitoring_v2.SQL2016SyncLatency.Monitor |
WF EDM SQL 2016 Sync Latency Monitor |
Monitor |
15dc7901-73ca-18f6-02b6-ea6410bdb167 |
WF.SQL.EDM.AOAG.Latency.Monitoring_v2 |
false |
True |
MatchMonitorHealth |
Normal |
False |
This monitor uses a SQL command in a PowerShell script to measure sync latency in AlwaysON, Database Mirroring, and Log Shipping. |
| Name |
Value |
| BagType |
multi |
| CD_CriticalExpression |
System.Xml.XmlElement |
| CD_HealthyExpression |
System.Xml.XmlElement |
| CD_InstanceFilterExpression |
System.Xml.XmlElement |
| CD_WarningExpression |
System.Xml.XmlElement |
| ConnectDBName |
|
| ConnectionString |
$Target/Host/Property[Type="MSQL2016D!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$ |
| InstanceName |
|
| IntervalSeconds |
3600 |
| MatchCount |
0 |
| MetricName |
LatencyInMinutes |
| MetricUnits |
Minutes |
| ProbeActionTimeoutSeconds |
300 |
| RetryQueryCount |
1 |
| SampleCount |
0 |
| ServerName |
$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ |
| SQLCMD |
-- SCOM Latency Monitoring Script (SyncLatency.SQL)
-- 2020.05.05: Tyson cleaned up some of the SELECT AS column names
-- 02/22/2019
-- Prem: Modified code to include table variable @LAT_MON and introduced cast to convert SERVERPROPERTY for ServerName column
USE msdb;
--GO
SET NOCOUNT ON
--GO
EXEC sp_dbmmonitorupdate;
DECLARE @query VARCHAR(MAX)
DECLARE @dbname SYSNAME
DECLARE @databases TABLE (dbname SYSNAME)
DECLARE @LAT_MON TABLE (
[SQLServerName] NVARCHAR(128)
,SQLInstancename NVARCHAR(100)
,DatabaseName NVARCHAR(100)
,SyncType VARCHAR(50)
,LatencyInMinutes BIGINT
);
INSERT INTO @databases
SELECT db_name(database_id)
FROM sys.database_mirroring
WHERE mirroring_guid IS NOT NULL
DECLARE @Mirroring_Monitor TABLE (
[Database_name] NVARCHAR(100)
,[Role] BIT
,[Mirroring_State] INT
,[witness_status] INT
,[log_generation_rate] BIGINT
,[unsent_log] BIGINT
,[send_rate] BIGINT
,[unrestored_log] BIGINT
,[recovery_rate] BIGINT
,[transaction_delay] BIGINT
,[transactions_per_sec] BIGINT
,[average_delay] BIGINT
,[time_recorded] DATETIME2
,[time_behind] DATETIME2
,[local_time] DATETIME2
)
WHILE EXISTS (
SELECT TOP 1 dbname
FROM @databases
)
BEGIN
SET @dbname = (
SELECT TOP 1 dbname
FROM @databases
)
SET @query = 'EXEC sp_dbmmonitorresults ''' + @dbname + ''';'
INSERT INTO @Mirroring_Monitor
EXEC (@query)
DELETE
FROM @databases
WHERE dbname = @dbname
END
DECLARE @log_shipping_monitor TABLE (
[status] BIT
,is_primary BIT
,[server] NVARCHAR(100)
,[database_name] NVARCHAR(100)
,[time_since_last_backup] BIGINT
,[last_backup_file] NVARCHAR(255)
,[backup_threshold] BIGINT
,[is_backup_alert_enabled] BIT
,[time_since_last_copy] BIGINT
,[last_copied_file] NVARCHAR(255)
,[time_since_last_restore] BIGINT
,[last_restored_file] NVARCHAR(255)
,[last_restored_latency] BIGINT
,[restore_threshold] INT
,[is_restore_alert_enabled] BIT
)
INSERT @log_shipping_monitor
EXEC master.dbo.sp_help_log_shipping_monitor
DECLARE @num INT
,@retVal INT;
SELECT @num = CAST(SERVERPROPERTY('IsHadrEnabled') AS INT)
IF (@num = 1)
BEGIN
INSERT @LAT_MON
SELECT CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NVARCHAR(128)) AS [SQLServerName]
,AR.replica_server_name AS [SQLInstanceName]
,db.name AS [DatabaseName]
,'AG = ' + ALG.name AS [SyncType]
,DATEDIFF(MINUTE, drs.last_hardened_time, GETDATE()) AS [LatencyInMinutes]
FROM sys.availability_replicas AS AR
INNER JOIN sys.dm_hadr_database_replica_states AS DRS ON DRS.replica_id = AR.replica_id
INNER JOIN sys.availability_groups ALG ON ALG.group_id = AR.group_id
INNER JOIN sys.databases db ON db.database_id = drs.database_id
WHERE DRS.is_primary_replica = 0
AND AR.replica_server_name = @@SERVERNAME
UNION
SELECT CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NVARCHAR(128)) AS [SQLServerName]
,@@ServerName AS [SQLInstanceName]
,database_name AS [DatabaseName]
,'Log Shipping' AS SyncType
,time_since_last_restore AS [LatencyInMinutes]
FROM @log_shipping_monitor m
JOIN sys.databases d ON m.database_name = d.name
WHERE time_since_last_restore IS NOT NULL
UNION
SELECT CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NVARCHAR(128)) AS [SQLServerName]
,@@ServerName AS [SQLInstanceName]
,database_name AS [DatabaseName]
,'DB Mirroring' AS SyncType
,DATEDIFF(MINUTE, ISNULL(time_behind, DATEADD(DAY, - 31, time_recorded)), time_recorded) AS [LatencyInMinutes]
FROM @Mirroring_Monitor a
END
ELSE
BEGIN
INSERT @LAT_MON
SELECT CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NVARCHAR(128)) AS [SQLServerName]
,@@ServerName AS [SQLInstanceName]
,database_name AS [DatabaseName]
,'Log Shipping' AS SyncType
,time_since_last_restore AS [LatencyInMinutes]
FROM @log_shipping_monitor m
JOIN sys.databases d ON m.database_name = d.name
WHERE time_since_last_restore IS NOT NULL
UNION
SELECT CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NVARCHAR(128)) AS [SQLServerName]
,@@ServerName AS [SQLInstanceName]
,database_name AS [DatabaseName]
,'DB Mirroring' AS SyncType
,DATEDIFF(MINUTE, ISNULL(time_behind, DATEADD(DAY, - 31, time_recorded)), time_recorded) AS [LatencyInMinutes]
FROM @Mirroring_Monitor a
END
IF EXISTS (
SELECT *
FROM @LAT_MON WHERE LatencyInMinutes is not Null and LatencyInMinutes >= 0
)
BEGIN
SELECT * FROM @LAT_MON WHERE LatencyInMinutes is not Null and LatencyInMinutes >= 0
END
ELSE
BEGIN
SELECT '0' AS ServerName
,'0' AS SQLInstanceName
,'NO_ELIGIBLE_DBs' AS DatabaseName
,'0' AS SyncType
,'0' AS LatencyInMinutes
END
|
| SQLCMDTimeoutSeconds |
30 |
| SyncTime |
|
| ThresholdHighCritical |
480 |
| ThresholdHighWarning |
360 |
| ThresholdLowCritical |
-2 |
| ThresholdLowWarning |
-2 |
| UniqueItemName |
DatabaseName |
| WorkflowName |
WF.SQL.EDM.AOAG.Latency.Monitoring_v2.SQL2016SyncLatency.Monitor |
| WriteToEventLog |
false |
|
|
| 121 |
OperationsManager |
e2071a60-533b-11b0-07b0-705040926522 |
DB01.CONTOSO.COM;MSSQLSERVER |
Microsoft.SQLServer.2016.Database |
9046bf42-e42e-b7df-2ac8-3c0675a88c48 |
Microsoft.SQLServer.2016.DependencyMonitor.XTPConfigurationMonitor |
XTP Configuration (rollup) |
Monitor |
b344d23e-4521-e6aa-5b0f-cdff8a8f5c2a |
Microsoft.SQLServer.2016.Monitoring |
true |
False |
|
|
False |
This monitor checks the status of the SQL Database XTP Configuration. This monitor is a dependency (rollup) monitor.
Note that this monitor works only with Enterprise, Developer, and Evaluation editions of Microsoft SQL Server. With other editions, the monitor will always be in healthy state. |
|
|