O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required