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?
 
Ramesh Babu VavillaConnect With a Mentor Commented:
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
 
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
jso2765Author Commented:
Server trigger recursion = 1
MAX Server Memory = 20480(MB)
MIN Server Memory = 20480(MB)
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.