Memory USage

Question

Memory USage

Tara-1044200

SSCoach

Points: 15951
More actions
May 15, 2009 at 1:54 pm

#137833

we just have sql server on the box, no other application and though there was no process running on sql server ( i checked sp_who2) but still the physical memory usage is 99%, how to troubleshoot?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ted Krueger Ten Centuries Points: 1171 More actions · Answer 1

There may be nothing to troubleshoot. By the nature of SQL Server it will consume as much memory as you allow it to have. Once it does so, it will not release it unless you force the issue.

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 2

Hi Tara

You should restrict your SQL Server instance not to use the complete memory. SSMS -> right click your SSE instance -> Memory. Configure a value which depends on your available system resources to ensure that your OS can work proper. SQL Server usually does not free RAM.

Greets

Flo

Tara-1044200 SSCoach Points: 15951 More actions · Answer 3

right now i set it up to use 80% of the available memory but though there is nothing running on sql server why does full 80% is used, any reason?

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 4

Hi Tara

Two reasons:

1.) You configured "Minimum server memory" and "Maximum server memory" to same value.

2.) SQL Server needs (or needed once) for some reason. Memory allocation and freeing takes too much overhead so it does not free any memory.

Greets

Flo

Tara-1044200 SSCoach Points: 15951 More actions · Answer 5

minimum is set to = 0

max is set to = 28672 MB out of 32GB.

Tim Walker. SSCertifiable Points: 5173 More actions · Answer 6

Tara, it is unlikely you need to worry.

If you leave SQL Server to determine how much memory it needs it will normally do this accurately. Normally it grabs as much free memory as is available to do it's caching. However if other applications need the space it will release it.

So as I say, don't worry unless you have seen something else that indicates a performmance issue.

Tim

.

Ted Krueger Ten Centuries Points: 1171 More actions · Answer 7

Tim is correct in not to worry unless you are asking due to performance issues you may be experiening. I have 12 instances that stay at 100% memory usage per allocated allowance. This is normal once the engine has time to fill the cache. Unless the engine is forced to recycle, it will not.