The MS SQL Memory Structures Layer

This layer tracks the health of the memory and buffer structures of a Backup SQL server.

Figure 1 : The tests associated with the MS SQL Memory Structures layer

Refer to the following topics for the detailed discussion on these tests:

• SQL Buffers Test
• SQL Buffer Nodes Test
• SQL Cache Test
• SQL Locks Test
• SQL Lock Waits Test
• SQL Latches Test
• SQL Memory Test