I have a server running MS Server 2008. It has 24GB of memory. I am running a 425 GB SQL 2008 SQL database. The application seems to be eating up all the memory on the server.

I have a server running MS Server 2008. It has 24GB of memory. I am running a 425 GB SQL 2008 SQL database. The application seems to be eating up all the memory on the server. But the resource monitor does not reflect anywhere near that amount. The page file is 4GB. My question is could we have the system configured incorrectly to be tasking the memory to this degree?
jso2765Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mass2612Commented:
Hi,

Is the application that accesses the database actually running on the MS SQL server? What's your min and max memory set to for the instance? Is there only 1 instance and anything else running on this server?
select name, value from sys.configurations where name like '%server memory%'

Open in new window

0
käµfm³d 👽Commented:
Our server @ work has 16 GB and @ one point it was hogging all the memory. IIRC, SQL Server, by default, will try to use all available memory. Unfortunately, I don't know what setting needs to be changed since I'm a dev. If you don't get a specific answer by tomorrow, I'll ask @ work for the location of the setting.
0
jso2765Author Commented:
Server trigger recursion = 1
MAX Server Memory = 20480(MB)
MIN Server Memory = 20480(MB)
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

mass2612Commented:
Ok so you have SQL server limited to use a max of 20GB of the RAM it also won't release any of the 20GB back to the OS but that's ok depending on what else is running on the server.

What's the application tier look like? Does the application actually run and execute its code on the database server? Do you have any other applications running on the server?
0
jso2765Author Commented:

Basically this server's primary function is to run SQL and it has our Vsphere client software running on it. But the application that is loading data to SQL is on a different server (VM).
0
mass2612Commented:
Is the application or SQL running slow or generating errors?

If you have not restarted the SQL instance for a while start by checking the standard report for memory consumption - Open SSMS > Connect to the Instance > Right click the instance name > Reports > Standard Reports > Memory Consumption - what does this show you?
0
jso2765Author Commented:
MemoryClerk_SQLBufferPool is by far the largest consumer @ 25,214,216 KB Virtual Memory Reserved - 21,313,280 KB AWE Memory Allocated. Cachestore_objcp = 708,248.
0
Anthony PerkinsCommented:
Aside from the fact that SQL Server by design uses all the memory made available to it, what is the problem?
0
jso2765Author Commented:
Sluggish Performance mainly. This is a production environment and we do Microsoft Updates sporatically. Could having a large number of pending udates affect perfomance?
0
Anthony PerkinsCommented:
>>Sluggish Performance mainly.<<
Did you install SQL Server standalone as recommended?
I suspect you have some queries that need to be optimized.  You need to do some more homework and find out more specifics.

>>Could having a large number of pending udates affect perfomance? <<
Should not be a problem.
0
Ramesh Babu VavillaCommented:
hi if you use sql server 2008 64 bit, then it is the default nature of the sql server 64 bit,
if you are using 32 bit, then use perfmon to monitor sql server performance .start-> run->perfmon->
memory-> availale MBytes if i t id les than 5 MB, then there is a memory leak, check the stored procedure, and where exacty memory is occupied, by default buffer pool is the highest consumer of memort
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.