Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005application.Eachnight，dataisimportedintoadatabase，andthedatabaseisthensettoberead-only.Duringbusinesshours，usersrunpredefinedandadhocqueries.Youneedtomonitortheserversperformanceduringtheday.Whataretwopossiblewaystoachievethisgoal？（）
A.UsetheLockWaits/secperformancecounter.
B.UsetheNumberofDeadlocks/secperformancecounter.
C.UsetheTransactions/secperformancecounter.
D.UsetheFullScans/secperformancecounter.
E.UsetheBatches/secperformancecounter.

A.ThecompanyusesaSQLServer2005application.Eachnight，dataisimportedintoadatabase，andthedatabaseisthensettoberead-only.Duringbusinesshours，usersrunpredefinedandadhocqueries.Youneedtomonitortheserversperformanceduringtheday.Whataretwopossiblewaystoachievethisgoal？（）
A.UsetheLockWaits/secperformancecounter.
B.UsetheNumberofDeadlocks/secperformancecounter.
C.UsetheTransactions/secperformancecounter.
D.UsetheFullScans/secperformancecounter.
E.UsetheBatches/secperformancecounter.

【参考答案】

D, E