January 28, 2014 at 12:31 am
Hello,
I'm just starting out with SQL Server 2012 and have a few databases running on it. System is Win 2008 64 bit with SQL server 2012 Standard 64 bit, 16 GB RAM. Everything started out fine, but have found that after loading SSRS, the sqlsrvr.exe process is consuming all available physical memory (95-99%). Initial google searches revealed some direction, i.e. capping memory, as well as some posts about 64 bit consuming all available memory because the max is an astronomical number. Microsoft recommends it being set dynamic, but if this is the case, on a 64 bit machine, it makes sense that it will go as high as it can. Any insights/recommendations on this? I set it use 12GB out of 16 and it dynamically dropped it down, but I get the impression this isn't the 'best practice'.
Thank you in advance!
January 28, 2014 at 1:04 am
If you leave max server memory at default, you're telling SQL it can use every scrap of memory on the machine. If that's not what you want (and it usually isn't), set max server memory to a sensible value. It's one of the few settings that I will almost always set on a server.
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply