how to reduce the memory useage of the sqlserver.exe process

Question

Post reply

how to reduce the memory useage of the sqlserver.exe process

polo.csit

SSCrazy

Points: 2574
More actions
December 11, 2009 at 7:00 am

#140609

Hi All,
how to reduce the memory useage of the sqlserver.exe process

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

polo.csit (12/11/2009)
Hi All,
how to reduce the memory useage of the sqlserver.exe process

What is it current usage, how much do you want to set it to and why have you decided to do this?

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

polo.csit (12/11/2009)
Hi All,
how to reduce the memory useage of the sqlserver.exe process

I have to ask the same question, why? Usually, SQL Server works better the more memory it has available as long as you don't starve the OS and other applications that may be running on the same server as SQL Server.

Lowell SSC Guru Points: 323518 More actions · Answer 3

on your laptop, this probably seems to make sense....everything "else" slows down, and task manager says sqlserver.exe is using almost all your memory.

As Bru and Lynn both pointed out, it's perfectly normal and acceptable on a server machine.

on your laptop, for development purposes, you could just stop the SQL service, and start it again only when you are developing again.

there are also minimum and maximum memory settings you can set in the server properties(Memory tab) when you connect with SSMS.

you typically would not limit memory on a production server in order to free up ram.

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!