New Book on Professional SQL Server 2005 Performance Tuning Approaches the Subject From a Different Perspective

DUBLIN, Ireland--(BUSINESS WIRE)--Research and Markets (http://www.researchandmarkets.com/reports/c85071) has announced the addition of Professional SQL Server 2005 Performance Tuning to their offering.

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 project's 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).

Covered in this Report:

Part I: Finding Bottlenecks when Something’s Wrong.

Chapter 1: Performance Tuning.

Chapter 2: Monitoring Server Resources with System Monitor.

Chapter 3: Monitoring SQL Server Resources with System Monitor.

Chapter 4: SQL ServerWait Types.

Chapter 5: Finding Problem Queries with SQL Profiler.

Part II: Removing Bottlenecks with Tuning.

Chapter 6: Choosing and Configuring Hardware.

Chapter 7: Tuning SQL Server Configuration.

Chapter 8: Tuning the Schema.

Chapter 9: Tuning T-SQL.

Part III: Preventative Measures and Baselining Performance with Tools.

Chapter 10: Capturing, Measuring, and Replaying a Workload Using SQL Profiler.

Chapter 11: Tuning Indexes.

Chapter 12: How Fast and Robust Is Your Storage?

Chapter 13: SQL Server 2005 Performance Dashboard Reports.

Part IV: Roadmap to Server Performance.

Chapter 14: Best Practices for Designing for Performance from the Start.

Chapter 15: Successful Deployment Strategies.

For more information visit http://www.researchandmarkets.com/reports/c85071.