单项选择题
You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）
A.Use the DBCC INPUTBUFFER command.
B.Use the sys.dm_exec_query_stats dynamic management view （DMV）.
C.Use the sqldiag utility.
D.Use the SHOWPLAN session option.
相关考题
-
单项选择题
YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1containsadatabasethatutilizesSQLServerlogshipping.Logshippingoccursevery30minutes.Eachnight，afullbackupismadeofthedatabase，andalldatabaseindexesarerebuilt.Thecompany’snetworkadministratorreportsthatSQL1snetworkutilizationbecomesexcessiveafterthenightlymaintenancetasksarecomplete.YouneedtoreducethenetworkbandwidthutilizationforSQL1.Whatshouldyoudo？（）
A.Configure the database to use the bulk-logged recovery model.
B.Each night， rebuild only those indexes that require it.
C.Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D.Increase the time between transaction log backups. -
单项选择题
Youareadatabaseadministratorforyourcompany.Eachnight，youperformfullbackupsofyourSQLServer2005computer.Duringbusinesshours，youperformhourlytransactionlogbackups.Yourebuilddatabaseindexeseachnight.Youneedtomodifyyourbackupstrategy.Youmustensurethatthedatabaserecoverstoanewserverasquicklyaspossible.Whatshouldyoudo？（）
A.Schedule the full backups to run after the nightly index is rebuilt.
B.Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
C.Schedule an additional transaction log backup to run after the nightly index is rebuilt.
D.Schedule a marker to be added to the transaction log before the nightly index is rebuilt. -
单项选择题
Youareadatabaseadministratorforyourcompany.Adatabaseononeofthecompany’sSQLServer2005computersstorestransactioninformationforthecompany’sWeb-basedordersystem.Thedatabaseisconfiguredtousethefullrecoverymodel.Yourcompanyreceivesveryfewordersbetweenthehoursof19：00and04：00.Yourmaximumacceptableriskfordatalossisonehour.Databasebackupsmustbeperformedasquicklyaspossible.Youneedtodevelopamaintenanceplantomanagethisrisk.Whatshouldyoudo？（）
A.Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.
B.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.
C.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.
D.Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.
