Features
- Cover Type: Paperback with 551 pages
- Published by: Wrox January 29, 2008
- Written in: English
- ISBN 10 Number: 0470176393
- ISBN 13 Number: 978-0470176399
-
Book Dimensions:
9.1 x 7.4 x 1.4 inches
- Weighs: 1.8 pounds
Book Description
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).
Back Cover Copy
Professional SQL Server 2005 Performance Tuning Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning.
Broken into four parts, the book first walks you through how to discover bottlenecks when something is wrong and how to monitor SQL Server to see whether there is a resource bottleneck. You'll then learn how to identify and remove the problems that are causing poor performance. The next section explains the preventive measures you can take to try to avoid a performance problem entirely. Finally, you'll learn how to achieve better performance and you'll take a look at some of the challenges involving performance tuning at the later stages of a product's life.
What you will learn from this book -
How to use the SQL Server wait types to find resource bottlenecks and the queries that are creating them -
Ways to tune and configure the schema so you can remove bottlenecks -
Techniques for creating standard workloads for use in performance testing -
Benefits of storage subsystem performance and robustness -
How to use SQLIO and SQLIOSim to their full potential -
Best practices for a successful deployment
Who this book is for
This book is for consultants, developers, DBAs, architects, or anyone with an interest in SQL performance. A working knowledge of T-SQL and knowledge of how to perform basic SQL Server and OS administrative tasks is necessary.
Wrox Professional guides are planned and written by working programmers to meet the real-world requirements of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Search for books at
