Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»»

High Memory is 70% & growing Fast Expand / Collapse
Author
Message
Posted Saturday, March 15, 2014 4:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 15, 2014 10:42 PM
Points: 7, Visits: 21
Fist you have to check fragmentation level, cap memory, add lock pages in memory, and last one is if you are using SQL Enterprise Edition , you can enable resource governor .
i sure that it will help you .
Post #1551457
Posted Saturday, March 15, 2014 8:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,614, Visits: 37,079
kshaileshbca (3/15/2014)
Fist you have to check fragmentation level


What's that got to do with memory?

add lock pages in memory


Um, no. That's not going to reduce memory usage, do you know what it actually does?

last one is if you are using SQL Enterprise Edition , you can enable resource governor .


To do what exactly? Just enable, no setting up groups and pools or any configuration at all?

i sure that it will help you .

Not.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1551479
Posted Tuesday, March 18, 2014 2:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:53 PM
Points: 42, Visits: 188
HI All,

Today my physical memory reached to 80% in my database server.
Please suggest what to do to reduce it now...


Thanks
Praneeth
Post #1552054
Posted Tuesday, March 18, 2014 2:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, December 14, 2014 11:59 PM
Points: 333, Visits: 555
Have you considered the advice of most people here in that you don't need to worry?!
Post #1552055
Posted Tuesday, March 18, 2014 3:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:33 AM
Points: 328, Visits: 3,623

I would suggest;
Get a coffee. Coffee's good.
Do your daily routine checks just in case there's actually something wrong. Rather than SQL Server doing exactly what it's supposed to do.
Drink coffee.
Read http://www.sqlskills.com/help/accidental-dba/?utm_source=accidentaldba&utm_medium=blogs&utm_campaign=training

Lots of interesting and important to know stuff in there. You may actually even, as a result of going through this, find stuff you actually need to worry about.

HTH

EDIT - reply to wrong post. Argh, who's this clown to give advice, eh?


I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1552057
Posted Tuesday, March 18, 2014 3:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:53 PM
Points: 42, Visits: 188
HI,

Its going high from 52% to 65,70,72 & today 80%...

tomorrow it may reach 90 & finally 100%...

Post #1552058
Posted Tuesday, March 18, 2014 3:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, December 14, 2014 11:59 PM
Points: 333, Visits: 555
praneethydba (3/18/2014)
HI,

Its going high from 52% to 65,70,72 & today 80%...

tomorrow it may reach 90 & finally 100%...



You are truly not grasping this. Just because 100% of the memory is being used does not mean you have a problem. It just means that SQL Server is using the allocation of memory that you have said it is allowed to use. The LRU algorythm will take care of the rest....
Post #1552061
Posted Tuesday, March 18, 2014 3:42 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,614, Visits: 37,079
praneethydba (3/18/2014)
HI All,

Today my physical memory reached to 80% in my database server.
Please suggest what to do to reduce it now...


Nothing. Same as I suggested last time, and the time before. Why are you worrying about normal, expected, desired behaviour?

If you want to reduce SQL's memory usage, set max server memory to some stupidly low value, then SQL will use very little memory. It'll perform terribly as a result of course, but since you seem to want lots of rather expensive memory going completely to waste, that'll do what you want.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1552071
Posted Tuesday, April 8, 2014 1:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:53 PM
Points: 42, Visits: 188
HI All,

After a long time.
Now my Database server physical memory reached to 90%...
Client is sitting next to me and asking for reasons...
I tried all the possible ways to see what exactly the sql is utilizing...

Please throw some thoughts for my problem...

Thanks
Praveen
Post #1559388
Posted Tuesday, April 8, 2014 2:18 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,614, Visits: 37,079
praneethydba (4/8/2014)
Client is sitting next to me and asking for reasons...


Tell him that SQL is designed to use all the memory it is allocated and that using 90% of the memory is a good thing.

You don't have a problem (except for a client that appears to refuse to believe you). you are seeing normal, expected, intended behaviour.
It's like saying, "My car goes fast when I press the accelerator, what's wrong?"

Now, we've repeatedly mentioned max server memory, and a chapter in a book all about memory, so by now you should be in a good position to know exactly what (not) to do in this situation.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1559397
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse