Specialized Performance Troubleshooting (Part 2: How to troubleshoot Memory problems in SQL Server)


This week we are looking into a very common performance issue of busy SQL Server instances: Lack of Memory.

There are various lack of memory issues and so I usually prefer to follow the below steps to identify exactly what the problem is:

I hope the above decision tree explains well how to detect and resolve memory problems.

 Two other counters I like to use as complimentary indicators are:
– SQL Server: Buffer Manager: Page Reads/sec: Big values (e.g. 200 or more) could indicate insufficient memory allocated to the SQL Server process
– SQL Server: Buffer Manager: Page Writes/sec: Big values (e.g. 200 or more) could indicate insufficient memory allocated to the SQL Server process

Next week I will discuss about detecting and explaining storage issues.

Comments (4)

  1. pmpjr says:

    enjoying your work, simple questions, easy to read and understand answers, carry on dude.

  2. John Daskalakis says:

    thanks! I try to keep it simple and to the point!

  3. Simon says:

    Just came across this article and I'm so happy to have stumbled on it. Thank you so much John.

  4. Learn The Things says:

    I  read this article and also few other articles by you. They are easy to understand and conveys the concept clearly with apt example. Thanks JohnDask!