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

 

Using AWE Memory in SQL Server 2000

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:

by Brad M. McGehee - In most SQL Servers, the biggest performance bottleneck is I/O. This makes a lot of sense for two major reasons. First, the purpose of a database is to store data, and data is stored on disk arrays, requiring I/O to retrieve the data from the disk array before it can be put into RAM for use. Second, disk access is the slowest component of any SQL Server. Combined, these two factors contribute to this common bottleneck.

 Read this article...
 Related Articles - For Members.
Performance Tuning for the Overworked DB2 Part 2: That Pesky I/O Bottleneck
A Programmer in DBA land
Performance Tuning for the Overworked DBA: Part 3: General Performance Considerations
Performance Tuning for the Overworked DBA. Part 1: The Performance Foundation
Reactivity to add Tarari accelerator to XML firewall
SQL Server Database Coding Conventions, Best Practices, and Programming Guidelines



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