SQL 2005 Meoory Hog

[paulovey]

Hi,

We have a customers server, running 4Gb Ram, with SBS 2003 Premium Edition.

The sql server is hogging 1.5Gb, even though it not being pushed that hard and only runs a small Database.

I have been doing a bit of reading and have a found a lot of conflicting articles on the use of AWE. So is there any other way of limiting the amount on memory that SQL 2005 will use?

Thanks,

Paul

If aint broken, dont try n fix it!!!!!

 

[Jamfool]

sql server will take as much memory as it can, unless you specify a max memory setting.

http://msdn.microsoft.com/en-us/library/ms190673.aspx

 

[mrdenny]

SQL Server is designed to use as much memory as it needs until it hits the upper limit that you have specified. By default SQL will use all memory on the server. AWE is used to allow the SQL Server to use more than 2 GB of memory.

You can limit the amount of memory that SQL Server can use by using the sp_configure procedure.

exec sp_configure 'max memory', 1024
reconfigure

The second memory is in MB.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Jamfool]

Thanks for clarifying.

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog