试题详情
- 单项选择题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）
A、The sp_executesql batches are not being recovered from the procedure cache.
B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
C、One new stored procedure is created by a database administrator.
D、Ad hoc batches are not being recovered from the procedure cache.
- B
关注下方微信公众号，在线模考后查看
热门试题
- 选择正确的选项（）
- You have
- You need
- Cer-tech .com&
- 您需要为在西雅图办公室的DHCPQ
- 请问，下面那个HTML元素能够在用户控件
- Your company has an
- You write a Web appl
- A Windows Communica
- Your company&e
- You have a
- Your network&e
- 你创建了一个Web窗体。你需要增加能够用
- Your network&e
- Your network&#
- 你正在创建一个应用。这个应用每分钟处理上
- Your company&#
- You are t
- 你正在开发一个显示产品信息的 Web 应
- You work