题目内容

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 the administrator of a SQL Server 2005 computer, and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQL01 is low. In addition, the disk activity is low. The cause of the performance problem should be identified. Which action should be performed?()

A. System Monitor should be utilized to have SQL1s cache hit ratio examined.
B. The sys.dm_db_index_physical_stats dynamic management function (DMF) should be examined.
C. The sys.dm_db_partition_stats dynamic management view (DMV) should be examined.
D. Task Manager should be utilized to have utilization of SQL1s network adapter examined.

查看答案
更多问题

槽状交错层理

成长小组组员聚会时讨论非常热烈,互不相让,甚至有相互攻击的行为。社会工作者除细心倾听组员的意见外,还应指出小组面临的冲突,让他们一起面对,寻求处理的办法。社会工作者运用的小组技巧有()。

A. 适当自我表露
B. 及时进行小结
C. 积极给予回应
D. 表达鼓励支持
E. 促进互动交流

ATP系统的工作原理是什么?

违法行为构成犯罪的。行政机关应当如何处理?

答案查题题库