SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


High Memory is 70% & growing Fast


High Memory is 70% & growing Fast

Author
Message
kshaileshbca
kshaileshbca
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
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 .
GilaMonster
GilaMonster
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217281 Visits: 46278
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, MVP, M.Sc (Comp Sci)
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


praneethydba
praneethydba
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 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
kevaburg
kevaburg
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4331 Visits: 1025
Have you considered the advice of most people here in that you don't need to worry?!
andrew gothard
andrew gothard
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2712 Visits: 5965
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.
praneethydba
praneethydba
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 Visits: 188
HI,

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

tomorrow it may reach 90 & finally 100%...
kevaburg
kevaburg
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4331 Visits: 1025
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....
GilaMonster
GilaMonster
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217281 Visits: 46278
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, MVP, M.Sc (Comp Sci)
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


praneethydba
praneethydba
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217281 Visits: 46278
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, MVP, M.Sc (Comp Sci)
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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search