PrepAway - Latest Free Exam Questions & Answers

What are two possible ways to achieve this goal?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 application. Each night, data is imported into a database, and the database is then set to be read-only. During business hours, users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Use the Batches/sec performance counter.

B.
Use the Full Scans/sec performance counter.

C.
Use the Lock Waits/sec performance counter.

D.
Use the Transactions/sec performance counter.

E.
Use the Number of Deadlocks/sec performance counter.

Explanation:
The Full Scans/Sec performance counter gives you the number of unrestricted full scans per second. These can be either base-table or full-index scans. The Batches/Sec performance counter gives you the number of batches per second that where completed successfully. Both these counters would give you the data needed to monitor the serves performance during daytime.


Leave a Reply