单项选择题

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 Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）

A.For the AdventureWorks database, enable Server Auditing
B.First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance
C.You should configure the data collector and make it capture the deadlock graphs
D.You should configure a SQL Profiler trace, and make it capture the deadlock graphs

<上一题目录下一题>

热门试题

单项选择题

YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatablenamedOrderthings.TheOrderthingstableispartitionedontheOrderIdcolumn.Thefirstpartitioncontainsintegervaluesgreaterthan100,000,whilethesecondpartitioncontainsintegervaluesbetween1and100,000.Youhavetoaddanewpartition.Thenewpartitionshouldcontainintegervaluesgreaterthan200,000.Whatshouldyoudo?（）

A.A new partition function should be created
B.You should change the existing partition scheme
C.You should use a Merge clause to change the existing partition function
D.You should use a Split clause to change the existing partition function

单项选择题

YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YoumustmakesurethatallSQLServerinstancesareconsistentlyconfiguredfornamingconventions,securitysettings,forceindexcreationandavoidanceofdatafragmentation.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should use the Database Engine Tuning Advisor.
B.In Microsoft SQL Server Management Studio, you should create a maintenance plan
C.You should use the SQL Server Configuration Manager
D.In Microsoft SQL Server Management Studio, you should create a policy