sql server 2008 64 bit, memory consumption

Question

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 ..... :(

Answer 1

0

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

answered Aug 17 '10 at 10:23 PM

Cyborg
10.2k ● 29 ● 39 ● 44

(comments are locked)

Answer 2

0

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

answered Aug 17 '10 at 10:54 PM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

(comments are locked)

sql server 2008 64 bit, memory consumption

Follow this question

Related Questions