Which two performance monitor counters should you monitor?

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.)

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 Performance

Sub-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



Leave a Reply 0

Your email address will not be published. Required fields are marked *