Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2(SP2). The server has 1 GB of RAM and a single hard disk.Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active.You are evaluating whether to add RAM to the server.You need to use System Monitor to find out whether adding RAM will decrease disk activity.Which performance counter should you monitor? ()
A. LogicalDisk : % Free Space
B. Memory : Pages Faults/sec
C. Memory : Free System Page Table Entries
D. Server Work Queues : Queue Length
第1题:
A.Windows2003server兼容性列表
B.硬件销售商列表
C.硬件兼容性列表
D.硬件抽象层
第2题:
YouaretheadministratorofaMicrosoftWindowsServer2003computernamedServer1.SQLServer2005isinstalledonServer1tohostadatabasenamedMedDB.TheMedDBdatabaseservesasthebackenddatabaseforanewclient/serverapplicationnamedMedDATA.InstallationoftheMedDATAapplicationcreatesthedatabaseschema,applicationroles,andadministrativeaccounts.Italsosetsallofthedefaultpermissions.YouneedtoestablishapermissionsbaselineforallobjectsintheMedDBdatabase.Whatshouldyoudo?()
A.UsetheSQLServer2005ManagementStudiotoreviewthepermissionsofthedefaultdatabaseobjects.
B.Querythesys.server_permissionstableonServer1.
C.Executethesp_helploginssystemstoredprocedureforeachofthedefaultusersthattheMedDATAapplicationcreates.
D.Querythesys.database_permissionsandsys.database_principalstablesintheMedDBdatabase.
第3题:
You have a server named Server1 that runs Windows Server 2003 Standard Edition Service Pack 2 (SP2).Server1 contains 4 GB of RAM and four processors.Users report that Server1 is slow. You run a performance report. The report displays the results shown in the following table.You need to improve the performance of Server1.What should you do?()
A. Add 2 GB of RAM and enable hyper-threading.
B. Add 2 GB of RAM and upgrade to Windows Server 2003 Enterprise Edition.
C. Add two processors and enable hyper-threading.
D. Add two processors and upgrade to Windows Server 2003 Enterprise Edition.
第4题:
A.错误
B.正确
第5题:
YouplantoimplementfourHyper-VhostsnamedServer1,Server2,Server3,andServer4.TheHyper-Vhostswillhavethefollowingconfigurations:
-Server3willhostonevirtualmachine(VM).
-Server4willhostfourVMs.
-ServerlandServer2willbeclusteredinaHyper-Vhostcluster.
-TheHyper-VhostclusterwillhosttwoVMs.
-AllVMswillrunWindowsServer2008R2Standard.
YouneedtorecommendwhichoperatingsystemmustbeinstalledoneachHyper-Vhost.Thesolutionmustminimizelicensingcosts.
WhichoperatingsystemshouldyourecommendforeachHyper-Vhost?
Toanswer,dragtheappropriateoperatingsystemtothecorrectHyper-Vhostintheanswerarea.
第6题:
【单选题】SQL Server 2008企业版不支持Windows操作系统版本是()。
A.Windows 2000 Server
B.Windows 2003 Datacenter Edition
C.Windows XP
D.Windows 2003 Server