 |
SQL Server Query Performance Tuning Distilled, 2nd Edition View Larger Image | Sajal Dam
Apress, Paperback, 2nd edition, Published October 2004, 597 pages, ISBN 1590594215 | List Price: $49.99
Our Price: $30.50
You Save: $19.49 (39% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 2 Average Customer Rating:  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:
Many SQL Server-based applications perform far below expectationcosting 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.
Table of Contents
Chapter 1 SQL Query Performance Tuning
Chapter 2 System Performance Analysis
Chapter 3 SQL Query Performance Analysis
Chapter 4 Index Analysis
Chapter 5 Index Tuning Wizard
Chapter 6 Bookmark Lookup Analysis
Chapter 7 Statistics Analysis
Chapter 8 Fragmentation Analysis
Chapter 9 Execution Plan Cache Analysis
Chapter 10 Stored Procedure Recompilation
Chapter 11 Query Design Analysis
Chapter 12 Blocking Analysis
Chapter 13 Deadlock Analysis
Chapter 14 Cursor Cost Analysis
Chapter 15 Database Connection Performance Issues
Chapter 16 Database Workload Optimization
Chapter 17 Scalability Scenarios
Chapter 18 SQL Server Optimization Checklist
About the Author
Sajal Dam has been working with Microsoft technologies for over 12 years and has a solid background in database application design. He also has significant experience troubleshooting and optimizing the performance of Microsoft-based applications, from front-end web pages to back-end databases.
While working as a development consultant for Microsoft, Dam helped many Fortune 500 companies maximize database performance, as well as design scalable database solutions. Currently an IT strategist at Dell, Dam manages optimization and baselining efforts of production databases, and works with application development teams to proactively identify and resolve performance bottlenecks.
Customer Reviews
Customer Reviews: 2 Average Customer Rating: Jan 9, 2008 Michael Dean from Ashburn, VA
Extremely useful - a must have for all SQL Developers and DBAs
The author has written an exceptionally helpful book. The book is organized into major categories and are presented with extenstive examples. After reading this book, I was able to rewrite an existing query and improve it dramatically. Between the index optimization and the join sequences, this proved to be an invaluable tool. I have switched from buying books from Wrox to Apress.
Jan 25, 2006
Comprehensive, detailed and clearly written.
A thorough, clear and detailed explanation of database optimization organized by each component of the process. This is the most complete of the 3 books I've read on the subject. The sample queries are concise and explained in detail.
The author conveys a treasure trove of practical information without getting lost in the details of SQL Server internals.
|
|
