Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 480 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

BUG: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

Consider the following scenario. You are running a 32-bit version of Microsoft SQL Server 2000 Service Pack 4 on an x86-based computer or on an x64-based computer. If Address Windowing Extensions (AWE) support is enabled, SQL Server 2000 can only use a maximum of 50 percent of the physical memory that is on the computer.

 Read this article...
 Related Articles - For Members.
Pitfalls of AWE on Microsoft SQL Server 2000 Environments
AWE and 3GB: An Empirical Picture
Enabling AWE Memory for SQL Server
SQL Server 7.0 Service Pack 4
FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
Microsoft Reminds Users About SQL Server 7.0 SP4 Patch
SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users
Microsoft Releases Windows 2000 Service Pack 4 (SP4)
Using AWE Memory in SQL Server 2000



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004