SQLTeam.com | Weblogs | Forums

Question about memory on SQL server


#1

Hi,

My SQL server has been running in the 90% consumption rate, with most of it being due to the SQL server it self.

  1. Is there a rule or formula to know if you have enough ram on your machine.
  2. is there a way to what the ram consumption over night, Like a recording or trace?

Thank you


#2

I set my SQL Server Max Memory manually to allow the OS enough to operate properly, generally I leave 20% for the OS. SQL will acquire and keep memory as it needs it. To avoid choking the OS use the Max Memory setting.


#3

Thanks for the reply.
But my question really how would I know if I have enough memory in the system.
For example we could have 32 GB and really need 90 GB.

I am looking for a formula or rule on this

I heard that 2-3 Gb per processor but I do not no if this is official or just someone's idea.

I am also wondering how to monitor my memory consumption.

Thank you


#4

You need to be monitoring for memory pressure to determine if you need more memory. Here are a few places you can review to see how to monitor for that condition:


https://www.brentozar.com/archive/2013/09/how-to-prove-your-sql-server-needs-more-memory-video/

There are plenty of articles available - you can search for SQL Server memory pressure.


#5

Okay I will look at these.
Thank you