High Performance Sql Server Dba Tunning & Optimization Secrets Includes Sql Server 2005

Tunnig & Optimization Secrets

If you’re a SQL Server DBA who wants to get proactive and organized with performance monitoring and tuning, then you’ve come to the right place. Written by one of the world’s top DBAs and SQL Server internals experts, Robin Schumacher offers real-world advice, an easy-to-follow performance strategy, and lots of SQL diagnostics scripts in a superb book that shows how to quickly diagnose and optimize SQL Server performance problems. As a Vice President at Embarcadero Technologies, Robin Schumacher has written the internals for some of the world’s most powerful SQL Server performance software, and now he shows you how to use the most recent advancements in SQL Server 2005, as well as SQL Server 7 and 2000, to make your database servers run as fast as possible.

Key Features

• Provides a winning performance methodology for use in analyzing any SQL Server database
  
  
• Demonstrates how to uncover serious bottlenecks that exist in your SQL Server
  
  
• Offers insight into how to determine the overall workload of a SQL Server
  
  
• Supplies methods for determining how and when to reorganize databases and objects
  
  
• Presents new techniques for monitoring and optimizing memory usage
  
  
• Presents improved methods for uncovering session-related bottlenecks
  
  
• Provides new tips and techniques for locating and fixing problem SQL
  
  
• Comes with online code depot with dozens of new performance analysis and monitoring scripts.

About the Author:
Robin Schumacher serves as the Worldwide Director of Product Management for MySQL, the world's leading open-source database management system. Robin has over fourteen years experience in database administration, development, monitoring, and tuning with Oracle, DB2, Teradata, Sybase, and Microsoft SQL Server.

He has authored countless performance-related articles for many database-centric magazines as well as serving as a database software reviewer and feature writer for the likes of Intelligent Enterprise, eWeek, DM Review, and others.