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.

Getting ready

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:% ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.