DBA Tips: Using AWE to increase SQL Server performance, and more...

[SearchDatabase.com]

Title: DBA Tips

September 29, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > PolyServe, Inc. IN THIS ISSUE:   >  SQL Server: Using AWE to increase performance   >  Oracle tuning: Blocksize and index tree structures   >  DBAs discuss end-user woes   >  SQL Server: Why cluster?   >  400 DB2 questions answered   >  Migrating SQL Server 2000 to Active Directory   >  Life as a DBA SQL Server: Using AWE to increase performance [Baya Pavliashvili] Using "Address Windowing Extensions" (AWE) to increase memory usage will increase the performance of SQL Server. Here's how. MORE INFO: > Hundreds more SQL Server tips and scripts Oracle tuning: Blocksize and index tree structures [Donald K. Burleson] Guru Don Burleson makes the case that the multiple blocksize feature improves the performance of Oracle indexes and that there are cases where query speed is improved by rebuilding indexes. DBAs discuss end-user woes [SearchDatabase.com] Some end users are happy with a short wait when calling up an application, others can be downright hostile. Properly managing the different pockets of end users in an organization is the key to being a successful DBA. SQL Server: Why cluster? [Buck Wood] There are two types of clustering in SQL Server: load balancing and failover. This short article examines the reasons for clustering and some of the system requirements. 400 DB2 questions answered [SearchDatabase.com] Author and SearchDatabase.com expert Craig Mullins has just hit the milestone of answering a whopping 400 of your DB2 questions. Browse this invaluable resource and get answers to questions about DB2-specific SQL, Oracle comparisons, resolving error messages, and much more. ITKNOWLEDGE EXCHANGE:  Migrating SQL Server 2000 to Active Directory When migrating a server that hosts a SQL Server 2000 instance from an NT Domain to an Active Directory Domain, what, if anything, needs to be done within SQL Server for everything to work properly? Click on the link to view responses to this question in the ITKnowledge Exchange.   Achieving Flexible Database Clusters with Oracle Learn the advantages of scalable on-demand clusters with Oracle9i RAC. IBM and PolyServe authors introduce the computing infrastructure known as Flexible Database Clusters and illustrate with a 14-node cluster of IBM Linux servers running Oracle9i RAC PolyServe cluster software. Attached to a formidable SAN configured with 206 disk drives, the cluster was tested with three database workloads. Click Here to View this Free White Paper.   FEATURED TOPIC:  Life as a DBA The DBA life has always been challenging but now new threats are emerging. The tips and advice inside will guide you along the perilous path to becoming a database guru... Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?track=NL-94 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494