SQL Server Query Optimization Workflow
2016-03-27 21:33:56 0 举报
SQL Server Query Optimization Workflow
作者其他创作
大纲/内容
Have more costly steps?
Apply a change to optimize costly execution step
Undo the change
Yes
Measure resource usage and performance of the query
Costly query cannot be optimized
Baseline performance and resource usage of costliest queries
Set performance target for costliest queries
No
Query Performance Accceptable?
Analyze and prioritize costly steps in execution plan
Query Performance Improved?
Costly query optimized
Some more optimization techniques available?
0 条评论
回复 删除
下一页