High Performance SQL Server DBA: Tuning & Optimization Secrets

A guide to troubleshooting and correcting SQL Server performance problems, this book provides a methodology for use in analyzing any SQL Server database. The most recent advances in SQL Server8i and 9i are covered to make a SQL Server database run as fast as possible. Properly using ratio-based and bottleneck analysis, designing a fast-running database from the ground up, and establishing methods for making storage and reorganization problems a thing of the past are demonstrated. Also presented are new techniques for monitoring and optimizing memory usage and improved methods for uncovering session-related bottlenecks.

A guide to troubleshooting and correcting SQL Server performance problems, this book provides a methodology for use in analyzing any SQL Server database. The most recent advances in SQL Server8i and 9i are covered to make a SQL Server database run as fast as possible. Properly using ratio-based and bottleneck analysis, designing a fast-running database from the ground up, and establishing methods for making storage and reorganization problems a thing of the past are demonstrated. Also presented are new techniques for monitoring and optimizing memory usage and improved methods for uncovering session-related bottlenecks.

Robin Schumacher is the vice president of product management for Embarcadero Technologies, a leading supplier of database software tools. Robin has more than 14 years of experience in database administration, development, monitoring, and tuning with Oracle, DB2, Teradata, Sybase, and Microsoft SQL Server. He is the author of several performance-related articles for many database-centric magazines as well as serving as a database software reviewer and feature writer for magazines such as DM Review, eWeek, and Intelligent Enterprise.