多项选择题
A.Use the Lock Waits/sec performance counter.
B.Use the Number of Deadlocks/sec performance counter.
C.Use the Transactions/sec performance counter.
D.Use the Full Scans/sec performance counter.
E.Use the Batches/sec performance counter.
单项选择题 You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do？（）
单项选择题 Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005computerthatrunsReportingServices.ReportingServicesisusedtoproducehundredsofreportseachday.YoudiscoverthattheReportServerTempDBdatabaseisgrowing.YouneedtominimizethesizeoftheReportServerTempDBdatabase.Whatshouldyoudo？（）
单项选择题 Youareadatabaseadministratorforyourcompany.Thecompany’sfinancialforecastingapplicationusesaSQLServer2005databasethatenablesbusinessuserstorunbothadhocandpredefinedqueries.Yoususpectthatsomequeriesconsumeanexcessiveamountofserverresources.Youneedtoidentifywhichqueriesconsumethemostresources.Youwanttoachievethisgoalasquicklyaspossible.Whatshouldyoudo？（）