Many SQL Server-based applications perform far below expectation costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.
SQL Server Query Performance Tuning Distilled, Second Edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ever-increasing workloads. With proven strategy, this book teaches you how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. Also covered are crucial issues like index analysis and tuning, preventing deadlocks, optimizing workload, and minimizing costs.
| Ch. 1 | SQL query performance tuning | 1 |
| Ch. 2 | System performance analysis | 17 |
| Ch. 3 | SQL query performance analysis | 59 |
| Ch. 4 | Index analysis | 95 |
| Ch. 5 | Index tuning wizard | 143 |
| Ch. 6 | Bookmark lookup analysis | 161 |
| Ch. 7 | Statistics analysis | 175 |
| Ch. 8 | Fragmentation analysis | 211 |
| Ch. 9 | Execution plan cache analysis | 243 |
| Ch. 10 | Stored procedure recompilation | 283 |
| Ch. 11 | Query design analysis | 315 |
| Ch. 12 | Blocking analysis | 365 |
| Ch. 13 | Deadlock analysis | 423 |
| Ch. 14 | Cursor cost analysis | 443 |
| Ch. 15 | Database connection performance issues | 473 |
| Ch. 16 | Database workload optimization | 491 |
| Ch. 17 | Scalability scenarios | 523 |
| Ch. 18 | SQL server optimization checklist | 547 |
Anonymous
Posted Tue Nov 16 00:00:00 EST 2004
Dam starts off by describing quite general problems that might arise in any relational database. He also wants you to inject some rigour into your efforts, by defining fundamental baseline metrics for your system usage. Then, when trying ideas described later in the book, you can get objective quantitative feedback on their efficacies. Of course, the bulk of the book is specific to SQL Server. But you should keep in mind that Dam is not primarily offering a bunch of quick tips on performance improvement. To be sure, the chapters do indeed give specific suggestions that you can try. But a more sophisticated reader can get an understanding of the broad constraints of SQL Server and a rough but good idea of its internal workings. You don't need source code for this. It sbould also be said that you need a good knowledge of SQL and the theory of relational databases, before venturing into the book. Some chapters (like on blocking and deadlock analysis) will considerably test this background. But the last chapter may be welcomed by some of you. It summarises the book by offering a detailed list of best practices. If you want to quickly gauge what the book has to offer, read the last chapter first.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Many SQL Server-based applications perform far below expectation costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.
SQL Server Query Performance Tuning Distilled, Second Edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ...