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

2012 SQL Server 2012 64 Bit Enterprise running on VMWare virtual server with 256 Gig of RAM Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 11:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 5:12 AM
Points: 1, Visits: 82
Not sure if this is the correct forum, but it appears that the single instance 2012 SQL Server 2012 64 Bit Enterprise with 225 Gig allocated to SQL running on VMWare is not allocating the correct memory. We have Minimum memory setup for 200 Gig and the Maximum for 225 Gig and the SQL server only is using roughly 20 Gig as viewed through SQL Sentry. The Page Life Expectancy is only round 5 to 8 and should be up around 300, so I'm not sure if anyone else has had this problem?

Any assistance would be appreciated or I can provide additional information as needed.

Thanks
Post #1460348
Posted Monday, June 10, 2013 3:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:10 AM
Points: 34, Visits: 148
Minimum doesn't mean it will start off at the min.

All it means is once it reaches the minimum threshold, it will never release it back to the OS when it doesn't need it anymore.
Post #1461454
Posted Monday, June 10, 2013 4:05 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 @ 5:18 PM
Points: 42,437, Visits: 35,492
Check the VM settings to ensure that the VM really does have that much memory and doesn't just appear to have it. Make sure the VM host isn't stealing back SQL's memory.

Page life expectancy of 300 is a very old recommendation that was barely valid when SQL usually had less than 4GB of memory, it's a completely incorrect guideline these days being way too low. A server with 200GB with a page life expectancy of 15000 is probably indicated as under severe memory pressure.



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 #1461462
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse