High Performance SQL Server DBA

ISBN: 9780976157366

作者: Robin Schumacher

出版社: Independent Pub Group

出版年: 2005-12

页数: 288

定价: $ 31.58

装帧: Pap

内容简介

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.