September 25, 2015 at 8:03 am
We have requirement that we have to reduce our production server RAM memory from 1 TB to 128 GB (our vendor suggested RAM 128 GB is enough to reduce the cost).
and I did monitor with third party tool and also checked with some scripts (DMV's,Views..etc) and observed there is only 8 KB and 16 KB memory utilizing for each session.
Total Physical memory is 1 TB, SQL Used memory is 934 GB and allotted SQL memory also same (but when i checked only 8 KB and 16 KB memory utilizing for each session).
How can i ensure exactly how much memory using by total sessions ?, so i can suggest to our client how much actual memory is needed.
can any one help out me ?
September 25, 2015 at 8:14 am
Sessions don't use the majority of SQL's memory. The main components will be the data cache (caching data so SQL doesn't have to go to disk) and the plan cache (caching plans so they don't have to be recompiled)
Both of those are optimisations, SQL uses memory to run more efficiently.
If SQL is using the full 1TB, there's a good chance you'll notice a performance degradation when you drop the memory down.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2015 at 9:26 am
Our Database size is 2 TB, Based on the Databases Size SQL Occupied RAM Memory ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply