Working Set Trimming can negatively impact SQL, Exchange, and Operating System performance under Windows 2003

Article translations Article translations
Close Close
Article ID: 2001745 - View products that this article applies to.
Expand all | Collapse all

Symptoms

Severe performance degradation under Windows 2003 due to the Working Set Trimming issue noted in KB956341.

 

If Microsoft SQL Server in use the following error in SQL Server log:

“A significant part of sql server process memory has been paged out. This may result in a performance degradation.” 

Given Microsoft Exchange and other server applications,  a sudden drop off in Process Object/Working Set noted via Performance Monitor

Example:  Excessive Paging on Exchange 2007

Cause

Windows 2003 behavior of paging all process Working Sets to disk in order to satisfy a driver memory request, same requests detailed in KB956341.

This behavior is changed in Windows 2008, please see resolution section below.

Resolution

Recommended:  Migrate to Windows 2008 x64 or 2008 R2 where this issue is sufficiently mitigated by architectural changes in the Windows Memory Manager.  On Windows 2008, consider installing the Dynamic Cache Service to moderate Windows Cache usage as a vector for this problem (service not required on 2008R2).  Note:  Windows 2003 will not be revised with the relevant Windows 2008 and higher changes and the potential root causes under 2003 are varied and hard to detect.

 

Windows 2003 Known Problem Driver Versions and Configuration Reference:

Contiguous Memory usage by Video Adapters - use /basevideo switch and use Device Manager to change display adapter to “Standard VGA Graphics Adapter”

Note:  The above configuration change in the video adapter is particularly important due to other adapters which have boundary restrictions for memory allocations (allocates below 4GB, such as storport.sys).  Such restricted drivers may not be changed for older device compatibility reasons.  Thus, limiting the usage of contiguous memory <4GB in the video adapter is often the best solution to allow even small allocations (we have seen 8MB) increased chance of success and thus not triggering a Working Set trim.  Also, we recommend removing any extraneous Network Adapter or Storage Adapter instances.  Extra adapters of this type will each consume a share of memory in this address range, increasing probability to encounter this problem under Windows 2003.

Disable Scalable Networking Pack

Upgrade from Windows 2003 SP1 Msgina.dll (fixed in Windows 2003 SP2)

Exchange Server Update Recommendations

Hotfix for Large File Copies in Windows 2003 SP1

Update Older HP iLO Driver

 

More Information

Working Set Trimming is the action Windows Memory Manager takes to satisfy physical memory demand under lower resource conditions.  This can have severe performance consequences under Windows 2003 and the consumers of physical memory responsible are variable and often difficult to identify.  Architectural changes in Windows 2008 mitigate this problem which affects SQL and Exchange Server performance.  The Dynamic Cache Service moderates Windows Cache usage for optimum stability on x64 in both Windows 2003 and 2008.  See also KB918483.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2001745 - Last Review: March 23, 2010 - Revision: 10.0
APPLIES TO
  • Microsoft Windows Server 2003 Compute Cluster Edition
  • Microsoft Windows Server 2003 R2 Datacenter Edition (32-Bit x86)
  • Microsoft Windows Server 2003 R2 Datacenter x64 Edition
  • Microsoft Windows Server 2003 R2 Enterprise Edition (32-Bit x86)
  • Microsoft Windows Server 2003 R2 Enterprise Edition KN
  • Microsoft Windows Server 2003 R2 Enterprise x64 Edition
  • Microsoft Windows Server 2003 R2 Standard Edition (32-bit x86)
  • Microsoft Windows Server 2003 R2 Standard Edition KN
  • Microsoft Windows Server 2003 R2 Standard x64 Edition
  • Microsoft Windows Server 2003 Service Pack 1
  • Microsoft Windows Server 2003 Service Pack 2
  • Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
  • Microsoft Windows Server 2003, Datacenter Edition for Itanium-Based Systems
  • Microsoft Windows Server 2003, Datacenter x64 Edition
  • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
  • Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems
  • Microsoft Windows Server 2003, Enterprise x64 Edition
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
  • Microsoft Windows Server 2003, Standard x64 Edition
  • Microsoft Windows Server 2003, Web Edition
Keywords: 
KB2001745

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com