Even growth DB files in filegroup |
1
|
MDW Appliance v2 Server
|
Even growth DB files in filegroup |
This monitor detects that -T1117 startup option is set for SQL Server. |
Increase the Number of Extents in the Database |
1
|
MDW Appliance v2 Server
|
Increase the number of Database Extents |
This monitor detects that -E startup option is set for SQL Server. |
Lock Pages in Memory |
0
|
SQL Server 2012 DB Engine
|
Lock Pages |
This monitor detects that the "Lock pages in memory" policy is enabled for SQL Server service account on the Microsoft Data Warehouse Appliance v2. |
MDW Appliance v2 Server Average CPU Performance Monitor |
0
|
MDW Appliance v2 Server
|
CPU overload |
Microsoft Data Warehouse Appliance v2 Server Average CPU Performance Monitor. |
SQL Server Agent service account monitor |
1
|
MDW Appliance v2 Server
|
Invalid Service Account |
Monitors whether SQL Server Agent service is running under the recommended account. |
SQL Server service account monitor |
1
|
MDW Appliance v2 Server
|
Invalid Service Account |
Monitors whether SQL Server service is running under the recommended account. |
Table Index Fragmentation |
1
|
SQL Server Table
|
Table Index Fragmentation |
This monitor detects that table has high clustered index fragmentation. |
Tempdb Autogrowth Monitor |
1
|
MDW Appliance v2 Server
|
|
Detects that autogrowth option is enabled for all files in the tempdb database. |
Tempdb Increment Step Monitor |
1
|
MDW Appliance v2 Server
|
|
Detects that autogrowth for all tempdb files is greater than or equal to 5% or 100 MB. |