You are the SQL administrator for your company. A SQL Server 2008 instance named SQL3 contains a databasenamed Sales.
The Sales database is accessed throughout the day. You need to monitor the amount of I/O generated by the instance.
Which two performance monitor counters should you monitor? (Choose two. Each correct answer represents partof the solution.)
A.
SQLServer: Databases: Transactions/sec
B.
SQLServer: Databases: Write Transactions/sec
C.
SQL Server: Buffer Manager: Page reads/sec
D.
SQL Server: Buffer Manager: Page writes/sec
E.
SQL Server: General Statistics: Logins/sec
F.
SQL Server: General Statistics: Logouts/sec
Explanation:
You should use the SQL Server: Buffer Manager: Page reads/sec and SQL Server: Buffer Manager: Pagewrites/sec counters to monitor the amount of I/O generated by the instance. These counters are helpful whenmonitoring disk usage. All of the other options are incorrect because none of these counters would be helpful in determining the amountof I/O generated by the instance. The SQLServer: Databases: Transactions/sec counter displays the number oftransactions started each second. The SQLServer: Databases: Write Transactions/sec counter displays thenumber of write transactions committed each second. The SQL Server: General Statistics: Logins/sec counterdisplays the total number of logins per second. The
SQL Server: General Statistics: Logouts/sec counterdisplays the total number of logouts per second.Objective:
Optimizing SQL Server PerformanceSub-Objective:
Use Performance Studio.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > MonitoringResource Usage (System Monitor) > Monitoring Disk Usage