SQL Server 2008 Query Performance Tuning Distilled

This book provides you with the tools you need to answer those questions. I’ll show you how to set up mechanisms for collecting performance data on your server for the SQL Server instances and databases living there. I’ll go over the more tactical methods of collecting data on individual T-SQL call...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Những tác giả chính: Fritchey, Grant, Dam, Sajal
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: Apress 2013
Những chủ đề:
SQL
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34785
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
id oai:scholar.dlu.edu.vn:DLU123456789-34785
record_format dspace
spelling oai:scholar.dlu.edu.vn:DLU123456789-347852014-01-20T01:40:29Z SQL Server 2008 Query Performance Tuning Distilled Fritchey, Grant Dam, Sajal SQL Computer This book provides you with the tools you need to answer those questions. I’ll show you how to set up mechanisms for collecting performance data on your server for the SQL Server instances and databases living there. I’ll go over the more tactical methods of collecting data on individual T-SQL calls. Along the way, I’ll be discussing index structure, choice, and maintenance; how best to write your T-SQL code; and a whole slew of other topics. One of my goals when writing this book was to deliver all these things using examples that resemble the types of queries you’ll see in the real world, at your desk. The tools and methods presented are mostly available with SQL Server Standard Edition, although some are available only with SQL Server Enterprise Edition. These are called out whenever you might encounter them. About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xix About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv CHAPTER 1 SQL Query Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 CHAPTER 2 System Performance Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 CHAPTER 3 SQL Query Performance Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 CHAPTER 4 Index Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101 CHAPTER 5 Database Engine Tuning Advisor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151 CHAPTER 6 Bookmark Lookup Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 CHAPTER 7 Statistics Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175 CHAPTER 8 Fragmentation Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 CHAPTER 9 Execution Plan Cache Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241 CHAPTER 10 Stored Procedure Recompilation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 283 CHAPTER 11 Query Design Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313 CHAPTER 12 Blocking Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351 CHAPTER 13 Deadlock Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 401 CHAPTER 14 Cursor Cost Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415 CHAPTER 15 Database Workload Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439 CHAPTER 16 SQL Server Optimization Checklist . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475 INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 497 2013-07-19T01:29:42Z 2013-07-19T01:29:42Z 2009 Book 978-1-4302-1902-6 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34785 en application/pdf Apress
institution Thư viện Trường Đại học Đà Lạt
collection Thư viện số
language English
topic SQL
Computer
spellingShingle SQL
Computer
Fritchey, Grant
Dam, Sajal
SQL Server 2008 Query Performance Tuning Distilled
description This book provides you with the tools you need to answer those questions. I’ll show you how to set up mechanisms for collecting performance data on your server for the SQL Server instances and databases living there. I’ll go over the more tactical methods of collecting data on individual T-SQL calls. Along the way, I’ll be discussing index structure, choice, and maintenance; how best to write your T-SQL code; and a whole slew of other topics. One of my goals when writing this book was to deliver all these things using examples that resemble the types of queries you’ll see in the real world, at your desk. The tools and methods presented are mostly available with SQL Server Standard Edition, although some are available only with SQL Server Enterprise Edition. These are called out whenever you might encounter them.
format Book
author Fritchey, Grant
Dam, Sajal
author_facet Fritchey, Grant
Dam, Sajal
author_sort Fritchey, Grant
title SQL Server 2008 Query Performance Tuning Distilled
title_short SQL Server 2008 Query Performance Tuning Distilled
title_full SQL Server 2008 Query Performance Tuning Distilled
title_fullStr SQL Server 2008 Query Performance Tuning Distilled
title_full_unstemmed SQL Server 2008 Query Performance Tuning Distilled
title_sort sql server 2008 query performance tuning distilled
publisher Apress
publishDate 2013
url http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34785
_version_ 1757663621941297152