发信人: zenny (智勇张肥头), 信区: Database
标 题: sql server 面试题 （4）
发信站: BBS 未名空间站 (Mon Oct 27 13:42:08 2008)
1. Developers reported that one db is very slow and ask you to tune up, what
should you do?
2. Now, you ruled out the hardware issue, the code issue, you think it might
be the fragmentation issue, how to verify that--you need show me the dbcc
command with correct parameters, remember it is 24X7 database.
3. Depends interviewee can answer the question 2, now explain what's the
meaning of the result.
※ 来源:·WWW 未名空间站 海外: mitbbs.com 中国: mitbbs.cn·[FROM: 12.174.]