All Unit Monitors in Microsoft.SQLServerAppliance.MDW2.Monitoring Management Pack

	DisplayName	Description	ID	Target	Parent Monitor	Category	Enabled	Instance Name	Counter Name	Frequency	Alert Generate	Alert Severity	Alert Priority	Alert Auto Resolve	Monitor Type	Remotable	Accessibility	RunAs
	MDW Appliance v2 Server Average CPU Performance Monitor	Microsoft Data Warehouse Appliance v2 Server Average CPU Performance Monitor.	Microsoft.SQLServerAppliance.MDW2.AverageCPUPerformanceMonitor	Microsoft.SQLServerAppliance.MDW2.Server	System.Health.PerformanceState	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServerAppliance.MDW2.ThreeStateAverageConsecutiveSamples	True	Public
	Lock Pages in Memory	This monitor detects that the "Lock pages in memory" policy is enabled for SQL Server service account on the Microsoft Data Warehouse Appliance v2.	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemory	Microsoft.SQLServer.2012.DBEngine	System.Health.ConfigurationState	ConfigurationHealth	False			0	True	Error	Normal	True	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemoryType	True	Public
	Increase the Number of Extents in the Database	This monitor detects that -E startup option is set for SQL Server.	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionE	Microsoft.SQLServerAppliance.MDW2.Server	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	Error	Normal	True	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOption	True	Public
	Even growth DB files in filegroup	This monitor detects that -T1117 startup option is set for SQL Server.	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionT1117	Microsoft.SQLServerAppliance.MDW2.Server	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	Error	Normal	True	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOption	True	Public
	SQL Server Agent service account monitor	Monitors whether SQL Server Agent service is running under the recommended account.	Microsoft.SQLServerAppliance.MDW2.SQLServerAgentServiceAccountMonitor	Microsoft.SQLServerAppliance.MDW2.Server	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServerAppliance.MDW2.ServiceAccountMonitorType	True	Public
	SQL Server service account monitor	Monitors whether SQL Server service is running under the recommended account.	Microsoft.SQLServerAppliance.MDW2.SQLServerServiceAccountMonitor	Microsoft.SQLServerAppliance.MDW2.Server	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServerAppliance.MDW2.ServiceAccountMonitorType	True	Public
	Table Index Fragmentation	This monitor detects that table has high clustered index fragmentation.	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentationMonitor	Microsoft.SQLServerAppliance.MDW2.Table	System.Health.PerformanceState	PerformanceHealth	True			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentationType	True	Public
	Tempdb Autogrowth Monitor	Detects that autogrowth option is enabled for all files in the tempdb database.	Microsoft.SQLServerAppliance.MDW2.TempDBAutogrowthMonitor	Microsoft.SQLServerAppliance.MDW2.Server	Microsoft.SQLServerAppliance.MDW2.TempDBConfiguration	ConfigurationHealth	True			0	False			True	Microsoft.SQLServerAppliance.MDW2.TempDBAutogrowthType	True	Public
	Tempdb Increment Step Monitor	Detects that autogrowth for all tempdb files is greater than or equal to 5\% or 100 MB.	Microsoft.SQLServerAppliance.MDW2.TempDBIncrementStepMonitor	Microsoft.SQLServerAppliance.MDW2.Server	Microsoft.SQLServerAppliance.MDW2.TempDBConfiguration	ConfigurationHealth	True			0	False			True	Microsoft.SQLServerAppliance.MDW2.TempDBIncrementStepType	True	Public