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...
Đã lưu trong:
Những tác giả chính: | , |
---|---|
Định dạng: | Sách |
Ngôn ngữ: | English |
Được phát hành: |
Apress
2013
|
Những chủ đề: | |
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 |