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

题目

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


相似考题
参考答案和解析
参考答案:B
更多“Your network contains a database server that runs Windows Server 2003 Standard Edition Ser ”相关问题
  • 第1题:

    有一台计算机,希望安装windows2003server。在准备安装过程,并希望判断硬件是否与windows2003server兼容。在何处可以找到硬件是否兼容的答案?()

    A.Windows2003server兼容性列表

    B.硬件销售商列表

    C.硬件兼容性列表

    D.硬件抽象层


    参考答案:C

  • 第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.


    参考答案:D

  • 第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.


    参考答案:D

  • 第4题:

    从Windows 2003 Server升级到Windows 2008 Server,补丁不用跟随升级,否则系统会降低兼容性。

    A.错误

    B.正确


    参考答案:A

  • 第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


    A