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