51搜题 >医卫类别 >医药类 >试题详情
题目

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? () 

A、You should use Dynamic Management Views 

B、You should use SQL Server Resource Governor 

C、You should use SQL Server Profiler 

D、You should use Windows System Monitor

提示:未搜索到的试题可在搜索页快速提交,您可在会员中心"提交的题"快速查看答案。
答案
查看答案
相关试题

可用于临床脾阳不足的肌衄证的方剂是()

A、理中汤

B、四物汤

C、四生丸

D、四君子汤

E、七厘散

下列各项中符合方剂组成要求的是()

A、每方必须君、臣、佐、使俱全

B、方中诸药均须有相应的针对症状

C、方中必有一药专作引经之用

D、君药的用量必须在全方总药量中所占比例最大

E、方中诸药既须主次有序,各司其职,又须密切配合,相与宣摄

天王补心丹的辨证要点是指()

A、失眠,惊悸,舌红苔黄,脉细数

B、失眠,心悸,手足心热,舌红少苔,脉细数

C、虚烦失眠,咽干口燥,舌红,脉弦细

D、精神恍惚,悲伤欲哭,舌红苔少,脉细

E、心悸失眠,体倦食少,舌淡,脉细弱

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?()

A、You should set query governor cost limit

B、You should set cost threshold for parallelism

C、You should set priority boost 

D、You should set precompute rank

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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? () 

A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 

B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 

C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 

D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

联系我们 会员中心
返回顶部