Sql Server Query Performance Tuning: Distilled - Couverture souple

Dam, Sajal

Couverture souple

ISBN 10 : 159059164X ISBN 13 : 9781590591642

Editeur : APress, 2003

Synopsis

Queries are one of the fundamental tools for manipulating data within SQL Server, and knowledge o f them is a necessity. This book uses a focused and practical approach to provide you with the most efficient methods to employ with queries. It focuses on the means SQL Server provides to understand the cost of a query, and provides recommendations for ways to remedy poorly-performing queries.All the information provided is based on the author's real-world experience and highlights the most cost-effective situations to everyday use of SQL Server. He details the steps that you can follow to troubleshoot and resolve SQL query performance.SQL Server Query Performance Tuning Distilled shows you:How to identify problematic SQL queries How to analyze a query execution plan How to evaluate the effectiveness of the current indexing techniques How to evaluate the effectiveness of statistics How to analyze and avoid stored procedure recompilation How to analyze plan caching How to analyze and minimize blocking How to analyze and avoid deadlocks How to analyze the cost of using a specific cursor type

A propos du livre

Présentation de l'éditeur

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. The 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 shows 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.

Biographie de l'auteur

Sajal Dam has been working on Microsoft technologies for over 12 years, with a strong background in database application design. Dam also maintains a strong background in troubleshooting and optimizing 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 optimized database performance, as well as design scalable database solutions. Currently an IT Strategist at Dell, Sajal Dam manages the optimization and baselining effort of production databases, and works with the application development teams to identify and resolve performance bottlenecks in advance.

Détails de l'édition

• Éditeur: APress
• Date d'édition: 2003
• Langue: anglais
• ISBN 10: 159059164X
• ISBN 13: 9781590591642
• Reliure: Broché
• Nombre de pages: 540
• Coordonnées du fabricant: non disponible