June 10, 2015 at 8:59 pm
Hi there, there seems to be a fair amount of conflicting information on the net so thought I'd direct my question here.
If I have a database server with no other applications running on it why would I want to reduce the memory.
From understanding the kernel will manage the memory accordingly therefore not having to reduce the sql allocation.
Any thoughts on the then great. Thanks!!!
--------------------------------------------
Laughing in the face of contention...
June 11, 2015 at 12:30 am
If you mean 'why do I need to set max server memory', it's because your server probably doesn't have the 2000 TB that SQL is by default allowed to try to allocate and you probably don't want SQL and the OS constantly playing the allocae memory, deallocate memory, allocate memory, deallocate memory game.
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply