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 |
---|
Tóm tắt: | 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. |
---|