n********6 发帖数: 1511 | 1 Tuning:
The stored procedure usually works well. Now it run for 10 minutes which is
abnormal. What would you do.
Answer: Depends on different scenario.
1. Generally it is a maintenance problem. e.g. fragments in index,
statistics needs to be updated...
2. Not likely to be development problem. (I missed one point that it can
also be dev problem, especially in the new released package to production.
Low performance might be caused by the new data flow processed by the logic
within stored procedure | B*****g 发帖数: 34098 | 2 顶
is
logic
【在 n********6 的大作中提到】 : Tuning: : The stored procedure usually works well. Now it run for 10 minutes which is : abnormal. What would you do. : Answer: Depends on different scenario. : 1. Generally it is a maintenance problem. e.g. fragments in index, : statistics needs to be updated... : 2. Not likely to be development problem. (I missed one point that it can : also be dev problem, especially in the new released package to production. : Low performance might be caused by the new data flow processed by the logic : within stored procedure
| B*****g 发帖数: 34098 | 3 add some points:
1. check execution plan for possible high load sql, may also need to check i
f the statistic got sth. wrong.
2. check if anything in procedure may lock the data too long.
3. Resource for this procedure like shared pool, large pool....
4. Recently major data change. Data change not only affect the statistic, al
so it may affect the performnce of the current work flow of the procedure.
5. The changes of objects referenced by this procedure. Like add a new index
to a table used in
【在 B*****g 的大作中提到】 : 顶 : : is : logic
|
|