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 456 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

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Pitfalls of AWE on Microsoft SQL Server 2000 Environments


 Article Abstract:

(Roy Golisano) This article covers a customer scenario where adding large amounts of memory negatively affected performance of their SQL Server 2000 cluster. This paper describes the methodology used to solve the customer’s problem.

 Read this article...
 Related Articles - For Members.
All Articles By Author

AWE and 3GB: An Empirical Picture
Enabling AWE Memory for SQL Server
Troubleshooting error 17803
Using AWE
Be Aware: Using AWE, locked pages in memory, on 64 bit
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
FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users
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

Reader Comments: Post Your Comments/Feedback

RE: Pitfalls of AWE on Microsoft SQL Server 2000 Environments
(posted: 4/8/2005 8:03:23 AM)
How does this information relate to Windows Server 2003?
Are there any differences in the use of /3GB and /PAE?

Thanks in advance...

Gé


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