SQL Server Memory Configuration calculation
-
I have 64 GB Physical RAM and i had set SQL Server Memory settings to 4 GB and Max Memory setting to 61.4 GB RAM, usually how to calculate how memory is left to windows and how much SQL sever is using.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Save a tree... Please don't waste paper unless you really need to!
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
I'm not 100% sure on the your question but to find how much memory SQL is currently using then use PERFMON.
MSSQL$<instance >:Memory Manager\Total Server Memory
-
If we say say MAX memory setting is 60 GB in SQL Server and does it mean 4 GB left for Windows?
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
Yes. Windows and any other processes you have on the server - other SQL Server components, for example.
John
-
SQL Server will use every bit of RAM that you give it (assuming you have enough data to fill the cache).
For a good calculation of how much RAM you should be allocating for the OS, I usually use Jonathan Kehayias recommendation[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Your max memory setting is too high for a 64GB box. BUT there is NO formula that can be right for all servers. Different people have different stuff running on them.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service -
Thanks for your answers, i had set my Max memory setting to 50 GB and now Target Server memory is showing as 51452 MB in performance counter so now i need to troubleshoot my SQL Server for better performance.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
After Setting 50 GB and now my Physical memory is 54 GB i don't know whether it will stop here, it is goes to 63 or 64 GB by tomorrow, can anyone explain.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
1) What build of sql server are you on?
2) How, EXACTLY, are you determining how much memory the SQL Server windows service is using?
3) Have you run dbcc memorystatus and used online resources to see if anything looks askew there?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service -
info.sqldbamail (4/28/2016)
Thanks for your answers, i had set my Max memory setting to 50 GB and now Target Server memory is showing as 51452 MB in performance counter so now i need to troubleshoot my SQL Server for better performance.I believe a 1GB setting in SQL = 1024MB of RAM so 50GB=51200MB
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply