July 23, 2012 at 10:53 am
We've got Sql Server 2005 SP4 Enterprise sitting on top of Win 2008 R2 Enterprise and everything is 64 bit. There is 32G of RAM available. The max server memory for Sql Server is set at 24G which leaves 8G for Windows. Isn't that excessive? Windows, at most, will use 4G, right?
July 23, 2012 at 11:30 am
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
July 23, 2012 at 11:51 am
I've found a variety of URLs that indicate that the most I would need for Windows is 4G for a total physical RAM of 32G. But I haven't really been able to find any "authority" URLs of the same and want to take sure that I am on the right track.
July 23, 2012 at 11:54 am
8GB reserved out of 32GB sounds a little excessive (but only you can confirm that by monitoring). At higher memory amounts (64, 128) 8GB reserved for the OS is not excessive at all.
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
July 23, 2012 at 12:31 pm
Are you running - or going to run either SSIS, SSRS or SSAS on this same box? If not, then 8GB is probably excessive - if you will be running those then 8GB for other processes may be what you need.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 23, 2012 at 12:48 pm
No, I am not running SSIS, SSRS, SSAS or any third party stuff, etc.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply