A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND.The database is refreshed periodically, but the resultset size of the queries does not fluctuate.Note the following details about this environment: A web applica

题目

A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND.The database is refreshed periodically, but the resultset size of the queries does not fluctuate.Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high.All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase.The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service.Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）

A.The Query Cache is pruning queries due to an increased number of requests

B.Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups

C.Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature

D.The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution

相似考题

1.Would overnight guests at an inn ___________ a husband and wife steal towels?A. running byB. run byC. operatedD. operating

2.下列连接字符实现与SQL Server数据库的连接，( )是不正确的。A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.\\SQLEXPRESS; Database=SchoolDB; Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

3.DOS的英文表示是()。A、Disk、Operating、SystemB、Daily、Operating、SystemC、Disk、Open、SystemD、Date、Open、System

4.用T2000DM工具备份的MO存放的目录可以任意选择,而用网管界面上的“数据库备份”备份后的MO只能存放在:()A./T2000/server/database/MOB./T2000/server/scriptC./T2000/server/database/dbbackup

更多“A database exists as a read－intensive server that is operating with query_cachek_type =DEM ”相关问题

  • 第1题：

    下面是该网站中数据库连接程序conn.inc的代码，请在空白处填入相应的程序代码。

    ＜%

    Setcorm=server.(1)("adodb.connection")

    conn.provider="sqloledb"

    provstr="server=127.0.0.1；database=(2)；uid=(3)；pwd=(4)"

    conn.open(5)

    %＞


    正确答案：(1)createobject (2)CJB (3)User (4)Test (5)provstr
    (1)createobject (2)CJB (3)User (4)Test (5)provstr

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

    下列连接字符实现与SQL Server数据库的连接，（）是不正确的。

    A．Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

    B．Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

    C．Data Source=.SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;

    D．Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;


    Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

  • 第4题：

    Main engines as well as auxiliary engines operating on heavy fuel should have continuousoon the lubricating oil, either according tothebypass or batch principles

    A.filtering

    B.centrifuging

    C.depositing

    D.operating


    答案：B

  • 第5题：

    下列连接字符实现与SQL Server数据库的连接，（）是不正确的

    A．Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

    B．Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

    C．Data Source=.SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;

    D．Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;


    Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

  • 第6题：

    19、下列连接字符实现与SQL Server数据库的连接，（）是不正确的。

    A．Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

    B．Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

    C．Data Source=.\\SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;

    D．Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;


    D

相关内容