SQL Server Memory Management Explained

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Craig Outcalt » SQL Server Memory Management Explained

20 posts, Page 1 of 2

1 2 »»

SQL Server Memory Management Explained

Rate Topic

Display Mode

Topic Options

Author

Message

SQLBOT

Posted Monday, September 19, 2011 9:55 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:22 PM
Points: 626, Visits: 835

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

Nakul Vachhrajani

Posted Tuesday, September 20, 2011 12:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:52 AM
Points: 1,277, Visits: 1,608

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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1177659

GregoryLPalmer

Posted Tuesday, September 20, 2011 1:16 AM

Forum 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

stuart-717928

Posted Tuesday, September 20, 2011 1:18 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 10:22 AM
Points: 14, Visits: 20

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

GregoryLPalmer

Posted Tuesday, September 20, 2011 1:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 6:59 PM
Points: 2, Visits: 12

stuart-717928 (9/20/2011)

I linked the correct program in my post above.

Post #1177676

giles.middleton

Posted Tuesday, September 20, 2011 2:17 AM

Forum 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

mohammed moinudheen

Posted Tuesday, September 20, 2011 4:29 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

Good article. Thanks.

Mohammed Moinudheen

Post #1177740

Sailor

Posted Tuesday, September 20, 2011 7:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:09 AM
Points: 236, Visits: 746

Can you clarify that current should be less than available?

See mine...

Post Attachments

si.JPG (22 views, 98.57 KB)

Post #1177882

Lucas Beris

Posted Tuesday, September 20, 2011 7:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, September 20, 2011 9:49 PM
Points: 9, Visits: 7

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

swellguy

Posted Tuesday, September 20, 2011 8:12 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:52 PM
Points: 16, Visits: 238

This was excellent; I appreciate your detailed sources, as well.

Post #1177922

« Prev Topic | Next Topic »

20 posts, Page 1 of 2

1 2 »»

Permissions