Search
InstantDoc ID
GO

Browse By: Author | Issue

December 21, 2004 08:21 PM

Memory Matters

Microsoft’s Customer Advisory Team explains how to use memory analysis to improve performance
Rating: (0)
Prakash Sundaresan
SQL Server Magazine
InstantDoc ID #44556
Analyzing SQL Server memory utilization is one of the techniques the SQL Server Customer Advisory team uses to help customers discover and rectify various performance problems. In "Minding Memory," September 2004, InstantDoc ID 43419, we looked at how SQL Server utilizes memory and how you can monitor that utilization. Now, let's learn how to use information about memory utilization to detect and correct performance problems.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Great article, all mysteory about memory explained in one article.
Raj Pochiraju, Microsoft

Venkata11/15/2005 2:58:07 PM

This has been very helpful but I have questions about the /3GB switch mentioned in the sidebar on 32/64 bit memory management. There is a lot of contradictory information going around about this switch and MSDN information seems to me a bit ambiguous.
Let's take SQL Server Enterprise addition on a dedicated Advanced Server with 4GB of physical memory. It is not clear to me exactly what the implications are for SQL Server's dynamic memory management. Does the /3GB switch require AWE to be enabled even though we are not going to use memory beyond 4GB? Does the AWE enabled configuration switch need to be set in SQL Server? Is the /3GB switch by itself the optimum memory configuration for this scenario? Is there a downside?

Regards,
Kurt Survance
SQL Consulting, Inc.

KURT2/8/2005 12:35:30 PM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.