High Performance SQL Server DBA: Tuning and Optimization Secrets - Softcover

Burleson, Donald Keith; Schumacher, Robin

Softcover

ISBN 10: 0976157365 ISBN 13: 9780976157366

Publisher: Rampant TechPress, 2005

Synopsis

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.

About this title

About the Author

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.

Edition details

• Publisher: Rampant TechPress
• Publication date: 2005
• Language: English
• ISBN 10: 0976157365
• ISBN 13: 9780976157366
• Binding: Paperback
• Number of pages: 288