题目

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

答案
查看答案
相关试题

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. 

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. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00. When you perform this back up, you must make sure that the overall backup will not be affected. What';s more, you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence.  In the options below, which Transact-SQL statement should you use?()

A、BACKUP LOG DB1 TO DISK = 't:/backups/db1.trn'; 

B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 

C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH NOUNLOAD; 

D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COPY_ONLY; 

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

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

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

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

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

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

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

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

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

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

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

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

热病后期,气阴两伤,余热未清,胃失和降,见身热汗出,渴饮少食,气逆欲呕,舌红苔少,脉虚数等。洽宜选用()

A、竹叶石膏汤

B、麦门冬汤

C、白虎汤加人参汤

D、清暑益气汤

E、青蒿鳖甲汤

最新解答的试题
提出现代生物-心理-社会医学模式是()

A.恩格尔B.波特C.托马斯·帕茨瓦尔D.比彻尔E.桑德斯
付款人在进行付款时无()

A.形式审查义务

B.实质审查义务

C.附带审查义务

D.票据外有关事项的审查义务
根据《公司法》的规定,有限责任公司下列人员中,可以提议召开股东会临时会议的是()。
A.总经理B.人数过半数的股东C.监事会主席D.人数为半数的董事
关于股份有限公司中的监事会,下列说法错误的是()

A.监事会负责提议聘请或更换外部审计机构B.监事会主席和副主席由全体监事过半数选举产生C.监事会中的职工代表的比例不得低于三分之一D.监事会应至少每6个月召开一次会议
三北精神的科学内涵