Monitoring the memory (RAM) usage of your database server is very important. There are a number of factors that can cause all your memory to be consumed. This is why you should monitor memory usage on a regular basis.
In this recipe, we will use Reliability and Performance Monitor to capture memory (RAM)-related usage statistics.
Before starting the recipe, it's important for you to know how to interpret the values of the following performance counters that we will be using in this example:
Memory:Available MBytes: This provides the amount of memory available on the system.
Memory:Pages/sec: This provides the number of pages that were read from, or written to, the disk, due to hard page faults.
Paging File:% Usage: This provides the amount, in percentage, of the paging that has occurred.
SQL Server:Buffer Manager:Buffer cache hit ratio: This provides the amount, in percentage, of the SQL Server data read from the cache and not from the...