当前在线人数8923
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:面试回来发考题2
[同主题阅读] [版面: 数据库] [作者:neil222966] , 2008年12月02日19:59:16
neil222966
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: neil222966 (Wei), 信区: Database
标  题: 面试回来发考题2
发信站: BBS 未名空间站 (Tue Dec  2 19:59:16 2008)

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 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.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996