SQL Server Query Performance Tuning Distilled

Author(s): Sajal Dam

Publisher: Apress

ISBN: 1-59059-421-5

More Details about the Book at Publisher's Site

SQLSquare Review:

SQL Server Query Performance Tuning Distilled by Sajal Dam (Publisher: Apress) is great resource for SQL Server Database Administrators, Developers and whoever who needs to tune SQL Server for performance.

SQL Server Query Performance Tuning Distilled is a very user-friendly, easy to understand, very well designed, and fun to read book. The book describes and explains each and every aspect of (a) SQL Server Performance Tuning and (b) SQL Server Query Performance tuning.

The book covers all the aspects on SQL Server Performance Tuning including System Performance (Processor, Memory & Disk), Query Performance, Execution Plans, Index Analysis, Index Tuning Wizard, Bookmarks, Statistics, Fragmentation, Blocking, Deadlocks, Query Design Analysis, Database connections, Workload optimization and much more…

The book, unlike other SQL Server performance tuning resources which just provide best practices and tips for performance tuning, describes each of these best practices and tips with easy, practical, detailed and step-by-step examples & tests that you can conduct to thoroughly understand the underlying concept and internal working of SQL Server from the performance viewpoint. I commend Sajal for describing hard to understand SQL Server internals very easily.

There are many sources for SQL Server best practices & performance tuning tips on the Internet (of course scattered across the web) and elsewhere, however, this is the best & well compiled resource that I have ever come across.

SQL Server Query Performance Tuning Distilled book from Apress is a valued resource for anyone who needs to identify & resolve poor performance issues with SQL Server Databases.