Professional SQL Server® 2005 Performance Tuning

Introduction

SQL Server is a tremendously successful database server that does an exceptional job of self-tuning. Out of the box SQL Server does a tremendous job of running well and delivering great performance with absolutely no user configuration. With the advent of cheaper hardware and the explosion of data, today's SQL Server systems are routinely operating in a space previously dominated by yesterday's enterprise class main frame system.

With the availability of cheap disks, disk controllers, and memory, almost anyone can now build a multi-terrabyte database on a reasonably modest system. This massive explosion of database size means that more SQL Server systems are pushing the frontiers of SQL Server's ability to self tune. Consequently, many more SQL Server users are experiencing performance problems.

This book provides a comprehensive resource for all the consultants, developers, database administrators, and anyone else who has to deal with SQL Server performance problems for the first time. It's also a great resource for anyone who already deals with SQL Server performance who needs a fresh look at how to do performance tuning.

This book approaches performance tuning from a new perspective. The book walks you through how to find performance problems, rather than assuming you already know what the problem is.

Who This Book Is For

If you are a consultant, developer, DBA, architect, or just someone with an interest in SQL performance, this is the book for you.

You will ...