x

sql server 2008 64 bit, memory consumption

HI Team, we are using SQL Server 2008 Standard edition on Windows server 2008 enterprise editoin,. still memory consumption is going on , and in odd time it never comes down, i know that SQL Server 64 bit is a bad in consumption of memory, but my client is much worried about the server. is there any alternative way to set the memory , other than

sp_configure 'show advanced options', 1;  
GO
RECONFIGURE;
GO
sp_configure 'max server memory', 4096;
GO
RECONFIGURE;
GO
other than this ..... :(
more ▼

asked Aug 17 '10 at 10:16 PM in Default

ramesh 1 gravatar image

ramesh 1
2.1k 59 67 69

tell your customer to change their assumptions, i.e. low free OS memory = bad to low free OS memory = SQL is doing it's job.
Aug 18 '10 at 07:11 AM Nick Kavadias
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

SQL Server OS dynamically manages the memory, SQL Server will consume the memory up to the limit that you specified on your server memory settings. If there is any memory requirement from the OSor any other application then only sql server will release the memory back to OS.

Refer : [SQL Server Memory Settings][1]

[1]: http://ask.sqlservercentral.com/questions/15447/sqlservrexe-memory-goes-on-increasing-and-never-comes-down?page=1#15456
more ▼

answered Aug 17 '10 at 10:23 PM

Cyborg gravatar image

Cyborg
10.6k 36 39 45

(comments are locked)
10|1200 characters needed characters left

Why are they concerned? Is it that they would like to see it drop or is there another function that the server performs that needs the memory. Yes SQL Server holds on to RAM a lot, but it does this based on usage experience and its prediction of future needs. If something else needs the RAM then you can use SSMS to configure the limits but all that does is put a UI over the top of the command you mention.

Personally, if nothing else needs it then I would not be concerned about the amount of memory used so long as you set the limit to allow at least 2GB for the OS
more ▼

answered Aug 17 '10 at 10:54 PM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x53

asked: Aug 17 '10 at 10:16 PM

Seen: 1861 times

Last Updated: Aug 18 '10 at 02:43 AM