The MS SQL Server Layer
The tests associated with this layer, indicate the following:
- Error frequency
- SQL engine performance
- SQL Uptime
- Buffer pool usage (specific to MS SQL 2005 and above)
- Active transactions and their effect on tempdb (specific to MS SQL 2005 and above)
- Blocked processes and how to deal with them
- The number and type of system processes currently running
Figure 1 : The tests associated with the MS SQL Server layer