Monitoring memory (RAM) usage
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:% ...