题目内容

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server has a very large database named DB1. An application which is constantly available uses DB1. Now you get a report from users, in the report users complain that server has a poor performance. As the technical support, you have to improve the performance of the application by using the Database Engine Tuning Advisor. Besides this, you must make sure that the action of analyzing the workload will not affect the performance of the production server.So what should you do?()

A. On the local server, enable the XP_MSVER stored procedure
B. On the remote server, enable the XP_MSVER stored procedure.
C. On the production server, use the dta.exe utility along with an XML input file.
D. You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file

查看答案
更多问题

女性青春期生长发育突增期发生在()

A. 月经初潮前3~4年
B. 月经初潮前1~2年
C. 月经初潮时
D. 月经初潮后1~2年
E. 月经初潮后3~4年

全面坚持四项基本原则的核心部分是()。

A. 坚持社会主义道路
B. 坚持马列主义、毛泽东思想
C. 坚持人民民主专政
D. 坚持党的领导

创新思维与领导决策的基本矛盾包括()。

A. 科学化与民主化的矛盾
B. 决与策的矛盾
C. 放与收的矛盾
D. 主要与次要的矛盾

汽轮机负荷过低会引起排汽缸温度升高,其原因是()

A. 真空过高。
B. 进汽温度过高。
C. 进入汽轮机的蒸汽流量少,不足以带走鼓风损失所产生的热量。
D. 进汽压力过高。

答案查题题库