YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Todayyounoticethatapplicationsthatrunontheserverhavepoorperformances.Youdoubtthatthishassomethingtodowithtablescans.YouhavetocapturetheappropriateinformationbyusinganappropriateWindowsSystemMonitorobject.Intheoptionsbelow,whichperformanceobjectshouldyouuse?（）A.You should use SQLServer:Buffer ManagerB.You should use SQLServer:Memory Manager C.You should use SQLServer:Databases D.You should use SQLServer:Access Methods

MCTS(70-432)

单项选择题

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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （）

A.You should use SQLServer:Buffer Manager
B.You should use SQLServer:Memory Manager
C.You should use SQLServer:Databases
D.You should use SQLServer:Access Methods

相关考题

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.TheserverhasaverylargedatabasenamedDB1.AnapplicationwhichisconstantlyavailableusesDB1.Nowyougetareportfromusers,inthereportuserscomplainthatserverhasapoorperformance.Asthetechnicalsupport,youhavetoimprovetheperformanceoftheapplicationbyusingtheDatabaseEngineTuningAdvisor.Besidesthis,youmustmakesurethattheactionofanalyzingtheworkloadwillnotaffecttheperformanceoftheproductionserver.Sowhatshouldyoudo?（）

单项选择题 YouworkinaOrganizationwhichisnamedWiikigoCorp.TheOrganizationusesSQLServer2008.YouaretheadministratoroftheOrganizationdatabase.NowyouareinchargeofaSQLServer2008instance.Lookatthefollowingquery:SELECTs.*,i.*FROMSensitiveTblASsINNERJOINInsensitiveTblASiONi.OrganizationName=s.OrganizationNameYouusetheabovequerytojointwotablesonacolumnnamedOrganizationName.Thefollowingerrorisreturnedwhenyouexecutethequery."Msg468,Level16,State9,Line17Cannotresolvethecollationconflictbetween'SQL_Latin1_General_CP1_CS_AS'and'SQL_Latin1_General_CP1_CI_AS'intheequaltooperation."TheONclauseofthequeryhastobemodifiedsothatitcanperformacase-sensitivejoinsuccessfully.Whatshouldyoudo?（）

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasewhichisnamedSellingsintheinstance.TheSellingsdatabasecontainsatablenamedProductions.Thetableisusedtostoresinformationaboutalltypesofproducts.TheProductionstableisoftenqueriedbyusersonthebasisoftheRadioSizecolumn.TheRadioSizecolumncontainstheNULLvalueforallproductsotherthanRadios.Currentlynoindex existsontheRadionSizecolumn.AccordingtotherequirementofthecompanyCIO,youhavetooptimizethequeryperformanceandreducetheeffectonthediskspacetotheleast.Sowhatactionshouldyouperformtoachievethisgoal?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064