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 «««123

SQL Server 2008 R2 Memory Hog Expand / Collapse
Author
Message
Posted Monday, March 10, 2014 12:13 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:29 PM
Points: 588, Visits: 900
Couple of things to look for.
1st Result set:
Available Physical Memory
System physical memory high
System physical memory low

2nd result set:
Target Committed
Current Committed




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1549424
Posted Monday, March 10, 2014 12:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 3:22 PM
Points: 16, Visits: 35
Available Physical Memory 523730944
System physical memory high 1
System physical memory low 0

I can't find Target Committed or Current Committed. I have


Committed 524288
Target 52428
Post #1549430
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse