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 Tuesday, April 8, 2014 3:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:48 AM
Points: 2,128, Visits: 1,488
Have you tried showing your client this Forum thread?!

Regards
Lempster
Post #1559409
Posted Tuesday, April 8, 2014 3:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 1:48 AM
Points: 53, Visits: 304
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...

Post #1559415
Posted Tuesday, April 8, 2014 3:45 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: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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 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 #1559416
Posted Tuesday, April 8, 2014 5:45 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 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)...

Post #1559442
Posted Tuesday, April 8, 2014 6: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,

My Page life Expectancy value is 80..
is there any memory leakage....
Post #1559448
Posted Tuesday, April 8, 2014 6:22 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: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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 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 #1559455
Posted Tuesday, April 8, 2014 6:22 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:04 PM
Points: 328, Visits: 3,624
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.
Post #1559456
Posted Tuesday, April 8, 2014 6:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:48 AM
Points: 2,128, Visits: 1,488
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
Post #1559463
Posted Tuesday, April 8, 2014 6:49 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:58 AM
Points: 1,591, Visits: 1,790
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.
Post #1559466
Posted Tuesday, April 8, 2014 10:10 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,

I dint run cleanbuffer..
Post #1559565
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse