Memory allocation
-
I am a new SQL server DBA and was checking the MAX memory on my SQL server instance and it is set to MAX which is 2147483647. I have 8gb on that instance and I have read different articles on how we should limit the memory. My question is how we determine how much memory we should allocate and why?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
-
i thinka decent rule of thumb for most SQL installations reserving 1/8th of the memory for the OSand apps, and 7/8ths for SQL server, plus or minus any special needs; so if you ran a lot of SSIS packages, for example, you might give the operating system 2 gig, and SQL only 6 of your 8 gig.
if your only running SQL locally on a dev machine,and doing a lot of development in Visual Studio, SQL's not a priority, so you might go 6 gig for OS and only 2 gig for SQL.
the default setting for sql tells it to take up to 2048 terabytes of RAM, so it can starve the OS and application for memory
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply