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
Lempster
Lempster
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3208 Visits: 1657
Have you tried showing your client this Forum thread?!

Regards
Lempster
Ashif Shaikh
Ashif Shaikh
SSC-Enthusiastic
SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)

Group: General Forum Members
Points: 121 Visits: 513
check the processes running in sys processses and the same using 'input buffer' and verify whether the query being run is fully optimized for eg indexes are missing and '*' in the queries instead of the column name.

Verify the processor affinity and IO affinity being used. I have came across the same situation and did the mentioned things to get rid of it.

Hope it solves your problem...

CoolCoolCoolCoolCool
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87313 Visits: 45272
sashif0 (4/8/2014)
Verify the processor affinity and IO affinity being used.


They should be at the defaults. They're also unrelated to memory usage.

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
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 188
Hi Newbie,

We are doing statistics updates on regular basis and Affinity is taken care by SQL server internally i guess.
when I execute sysprocess it is showing all the running id's with memory usage.
I have already mentioned I kept cap on sql server around 24GB i.e. 80% to sql server and remaining 20% to OS(total RAM is 32 GB)...
praneethydba
praneethydba
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

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

My Page life Expectancy value is 80..
is there any memory leakage....
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87313 Visits: 45272
What the hell gives you the idea that there's a memory leak?

Let's see...




Go and do some reading on how SQL uses its memory and how to monitor the memory.

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


andrew gothard
andrew gothard
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1059 Visits: 5791
praneethydba (4/8/2014)
HI,

My Page life Expectancy value is 80..
is there any memory leakage....


80?! On a 32 Gb box? Given how long it's taken your memory use to get up to 90% that seems rather remarkable. Are you sure about that, what query are you running?

Hang on, you haven't by any chance run the command to clear your buffer cache, to solve your memory 'problem', have you?

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Lempster
Lempster
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3208 Visits: 1657
As you seem unwilling to believe that what you are seeing is normal behavior for SQL Server, I can only reiterate my original somewhat flippant suggestion that you add more RAM to the server and then increase the Max Server Memory setting.
Or, you could instead spend the money on getting a consultant in to tell you what everyone on this forum thread has been telling you! ;-)

Regards
Lempster
sql_lock
sql_lock
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2136 Visits: 1950
Hi

I'm sorry but i have to agree with Gail on this. The links provided are a good read and an excellent place to start.

In addition Brent Ozar has a video outlining the things to check if you require more memory.

Also, there are a few good diagnostic queries within Glen Berry's blog. Query 35, 36, 44, 46 and 50 that will help identify (or point you in the right direction)

If all the advise you have been given appease you/client then I personally would seek the advice of a DB professional on a consultancy basis.
praneethydba
praneethydba
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

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

I dint run cleanbuffer..
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