We help IT Professionals succeed at work.
Get Started

SQL Server Question and RAM usage...

357 Views
Last Modified: 2012-05-09
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.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE