All Unit Monitors in Microsoft.SQLServerAppliance.MDW.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
	Lock Pages in Memory	This monitor detects that the "Lock pages in memory" policy is granted for SQL Server service account on Microsoft Data Warehouse Appliance.	Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory	Microsoft.SQLServer.2008.DBEngine	System.Health.ConfigurationState	ConfigurationHealth	False			0	True	Error	Normal	True	Microsoft.SQLServerAppliance.MDW.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.MDW.DBEngineStartupOptionE	Microsoft.SQLServerAppliance.MDW.Server	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	Error	Normal	True	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOption	True	Public
	Even growth DB files in filegroup	This monitor detects that -T1117 startup option is set for SQL Server.	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionT1117	Microsoft.SQLServerAppliance.MDW.Server	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	Error	Normal	True	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOption	True	Public
	Extent Fragmentation	This monitor detects that at least one table in the database has high clustered index fragmentation.	Microsoft.SQLServerAppliance.MDW.IndexFragmentation	Microsoft.SQLServer.2008.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServerAppliance.MDW.IndexFragmentationType	True	Public
	Tempdb Autogrowth Monitor	Detects that autogrowth option enabled for all files in tempdb database.	Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthMonitor	Microsoft.SQLServerAppliance.MDW.Server	Microsoft.SQLServerAppliance.MDW.TempDBConfiguration	ConfigurationHealth	True			0	False			False	Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthType	True	Public
	Tempdb Increment Step Monitor	Detects that autogrowth for all tempdb files is greater or equal than 5\% or 100 MB.	Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepMonitor	Microsoft.SQLServerAppliance.MDW.Server	Microsoft.SQLServerAppliance.MDW.TempDBConfiguration	ConfigurationHealth	True			0	False			False	Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepType	True	Public
	Tempdb Recovery Model Monitor	Detects that tempdb database has simple recovery model.	Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelMonitor	Microsoft.SQLServerAppliance.MDW.Server	Microsoft.SQLServerAppliance.MDW.TempDBConfiguration	ConfigurationHealth	True			0	False			False	Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelType	True	Public