Link to home
Start Free TrialLog in
Avatar of tdmgtech
tdmgtechFlag for United States of America

asked on

SQL Server Question and RAM usage...

Long story short, I inherited an older sql server.

Its running 2003 Server Entperise, but has SQL 2008 standard installed. At the time of acquisition it had 4gb of ram and 8 SQL instances installed.

It also had terminal services installed on it with people occasionally logging into it to run GIS applications which were dependent on SQL

For the time being, lets ignore all of the bad practices since I can't change this around for the next few months due to work flow.

The default instance would generally grab ~1.5 to ~2gb of ram and all of the others would suffer with whatever dregs they could snag.

I chucked 16gb of ram in the box, made sure /pae settings were set in the boot.ini, configured awe memory settings in sql, etc.

Now the SQL instances will only use ~170mb of ram. Performance is no worse, and maybe a little better, but I'd like SQL to actually USE the ram we've installed.

Note the server is using more ram, but I think a lot of it is going towards terminal sessions.

Its currently using ~9gb of ram, has 10gb of page file in use and has all 8 sql instances using ~150 to ~170mb of ram.

WTF.
Avatar of rcolumb
rcolumb

You mentioned there are 8 instances installed.  Did you do the following for each instance?

use master
go
exec sp_configure 'Max memory setting(MB); 1024
go
exec reconfigure override
go

This would give each instance a max memory of 1GB.  You can customize each instance according to the need and availability.
Avatar of tdmgtech

ASKER

Is independent of any AWE memory configs?  i've right click on the instance, gone to properties / memory and set awe memory to have a min of 1024mb and a max of either 2048mb or 4096mb depending on what instance it is.  Only one is set to 4096mb....
ASKER CERTIFIED SOLUTION
Avatar of tdmgtech
tdmgtech
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial