Why isn’t my SQL Server taking full advantage of all the RAM I have available in my server?

Question

I am the DBA of a SQL Server that has the memory setting configured to “Dynamically configure SQL Server memory, and the “Maximum Memory” set to 905MB out of a possible 1151MB. When I look at the Cache Size (pages) counter, it runs about 115MB. In addition, the Buffer Cache Hit Ratio counter is fine. Why isn’t my SQL Server taking full advantage of all the RAM I have available in my server?


Answer

SQL Server will only use up physical RAM if it really needs it. It won’t automatically use up all of the available RAM. It appears that your server has more than the necessary amount of RAM it needs to run efficiently. Because of this, it isn’t being used. Of course, as your server gets busier, or your database gets larger, you will find that SQL Server will automatically begin to use up more of the available RAM. It is always better to have too much RAM, than too little.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |