Trang này có hữu ích không?
Phản hồi của bạn về nội dung này rất quan trọng. Hãy cho chúng tôi biết suy nghĩ của bạn.
Phản hồi bổ sung?
Còn 1500 ký tự
Query Tuning
Nội dung này không sẵn có bằng ngôn ngữ của bạn nhưng đây là phiên bản tiếng Anh.

Query Tuning

Many administrators address performance problems solely by tuning system-level server performance: for example, memory size, type of file system, number and type of processors, and so on. However, many performance problems cannot be resolved this way. They are better addressed by also analyzing the application queries and updates that the application submits to the database, and how these queries and updates interact with the data contained in the database and the database schema.

Analyzing a Query

Contains information about displaying query execution plans by using Microsoft SQL Server Management Studio, Transact-SQL SET options, and by using SQL Server Profiler event classes in traces.

Finding Missing Indexes

Contains information about the SQL Server 2005 "missing indexes" feature. When the query optimizer analyzes a query to determine the best execution plan, it automatically generates information about indexes that would improve query performance even if the indexes do not exist. The missing indexes feature enables you to retrieve this information about missing indexes.

Query Tuning Recommendations

Contains information about what you can do to improve query performance.

Using Statistics to Improve Query Performance

Contains concepts and guidelines for using query optimization statistics effectively.

Advanced Query Tuning Concepts

Contains information about SQL Server join operations.

Nội dung của Cộng đồng

Hiển thị:
© 2015 Microsoft