 |
Professional SQL Server 2005 Performance Tuning
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
This book approaches Performance tuning from a new perspective. It shows readers
how to find performance problems, rather than assuming they already know what
the problem is. As such there is more emphasis on diagnostics than in any competitive
books. This book also takes a new approach in that we will discuss the limitations
imposed on performance tuning by the different stages of a projects life cycle,
and help the reader understand how this alters the performance tuning process.
We begin by covering aspects of general end-to-end application tuning (not
specific to SQL Server), but then very quickly move to SQL Server specifics,
starting with the high level stuff like the basic server resource counters for
CPU, memory, and IO, then trying to find the slow queries by looking at SQL
Wait types, and using Profiler to find long running, or blocked, or otherwise
poorly performing queries. We then move on to demonstrate how to "fix"
the performance of those poorly performing queries.
We also cover the different approaches the DBA might take depending on where
the target system is in its lifecycle. This includes the things you can do with
an application at the early stages of design (e.g., change pretty much anything
from the schema on up, including specifying different hardware). We then cover
the very different approach when working with a system running in production
(mostly index tuning, some server config, limited T-SQL tuning, no schema changes).
Table of Contents
I. Finding Bottlenecks when Something's Wrong.
1. Introduction to Performance Tuning.
2. Monitoring Server Resources with System Monitor.
3. Monitoring SQL Server Resources with System Monitor.
4. SQL Server Wait Types.
5. Finding Problem Queries with SQL Server Profiler.
II. Removing Bottlenecks with Tuning.
6. Tuning the Server.
7. Tuning SQL Server Configuration.
8. Tuning the Schema.
9. Tuning T-SQL.
III. Preventative Measures and Baselining Performance with Tools.
10. Capturing, Measuring, and Replaying a Workload Using SQL Profiler.
11. Tuning Indexes.
12. How Fast and Robust Is Your Storage?
13. SQL Server 2005 Performance Dashboard Reports.
IV. Roadmap to Server Performance.
14. Best Practices for Designing in Performance from the Start.
15. Successful Deployment Strategies.
|
|
