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 12»»

SQL Server Memory Management Explained Expand / Collapse
Author
Message
Posted Monday, September 19, 2011 9:55 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
Comments posted to this topic are about the item SQL Server Memory Management Explained

Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #1177620
Posted Tuesday, September 20, 2011 12:22 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 4:19 AM
Points: 1,437, Visits: 1,847
Good article, Craig! Learnt a few new things today with respect to troubleshooting memory pressure on the server.

Thank-you for taking the time out to compile your findings and write the article.


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1177659
Posted Tuesday, September 20, 2011 1:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 6:59 PM
Points: 2, Visits: 12
Nice article, I noticed one issue. You refer to the program you're running as process monitor in the article but I believe it is actually Process Explorer. Lost some time tracking down that issue since I haven't used either one in a long time. If you want to throw in a link, it is here on the TechNet site. I also noticed that the interface has changed in the new version.
Post #1177673
Posted Tuesday, September 20, 2011 1:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:10 AM
Points: 14, Visits: 23
I've just installed the latest version of Process Monitor 2.96 and cannot find an option to show the system information as you mention. Would you perhaps elaborate for us as there is no View option in this version of the program.
Post #1177675
Posted Tuesday, September 20, 2011 1:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 6:59 PM
Points: 2, Visits: 12
stuart-717928 (9/20/2011)
I've just installed the latest version of Process Monitor 2.96 and cannot find an option to show the system information as you mention. Would you perhaps elaborate for us as there is no View option in this version of the program.

I linked the correct program in my post above.
Post #1177676
Posted Tuesday, September 20, 2011 2:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 22, 2011 4:17 AM
Points: 1, Visits: 21

I believe there's an error in the article, circa 4,700,000 K is not 4.7MB, it's 4.7GB.


"The Available counter will show how many KB are available to the host;400 MB is probably as low as you would want to see it. The image above shows ~4.7 MB in the Available counter"
Post #1177687
Posted Tuesday, September 20, 2011 4:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:53 PM
Points: 2,278, Visits: 3,801
Good article. Thanks.

Mohammed Moinudheen
Post #1177740
Posted Tuesday, September 20, 2011 7:13 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 6:20 AM
Points: 247, Visits: 800
Can you clarify that current should be less than available?

See mine...






  Post Attachments 
si.JPG (22 views, 98.57 KB)
Post #1177882
Posted Tuesday, September 20, 2011 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 10, 2014 11:38 AM
Points: 9, Visits: 8
Hi, great article! I have a doubt when you say:
When the Current counter is larger than your Available counter it indicates that you are paging to disk
Isn´t part of the current memory already used by my process, that's why the available memory is lower? And maybe my process is not swapping to disk?

Thanks,
LKZ:
Post #1177885
Posted Tuesday, September 20, 2011 8:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 1:29 PM
Points: 16, Visits: 258
This was excellent; I appreciate your detailed sources, as well.
Post #1177922
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse