发信人: neil222966 (Wei), 信区: Database
标 题: 面试回来发考题2
发信站: BBS 未名空间站 (Tue Dec 2 19:59:16 2008)
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 and not well developed)
3. Bottleneck in hardware, CPU, I/O, memory, blablabla...
4. Busy Internet Traffic, problems in user desktop. Users cannot get the
output in 10 minutes.
※ 来源:·WWW 未名空间站 海外: mitbbs.com 中国: mitbbs.cn·[FROM: 71.163.]