Performance Monitor Interview Questions

Performance Monitor interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following option can be used to launch Perfmon ?

A. Type “start perfmon” at the command prompt

B. Go to Start | Programs | Administrative Tools | Performance Monitor

C. Go to Start | Run | Perfmon

D. All of the mentioned

Correct Answer is : All of the mentioned

2. Point out the wrong statement :

A. There are hundreds of Performance Counters

B. Performance Counters are very important to evaluate

C. SQL Server provides several tools for monitoring events in SQL Server and for tuning the physical database design

D. None of the mentioned

Correct Answer is : FALSE

3. Which of the following is one of the most crucial performance counters for monitoring ?

A. Disk Write Bytes/sec

B. Memory Queue Length

C. Virtual Memory

D. All of the mentioned

Correct Answer is : Disk Write Bytes/sec

4. _________ reports the total processor time with respect to the available capacity of the server.

A. Disk Read Bytes/sec

B. Avg.Disk Queue Length

C. Processor time

D. Response time

Correct Answer is : Processor time

5. Point out the correct statement :

A. Slow SELECT queries with high physical reads and low queue lengths demonstrates under performance of Disk read and write

B. If many simultaneous requests are waiting, investigate the process which is taking less time

C. SQL Server 2008 R2 Data Collection provides information about SQL Server processes and how these processes affect the current instance of SQL Server

D. All of the mentioned

Correct Answer is : Slow SELECT queries with high physical reads and low queue lengths demonstrates under performance of Disk read and write

Performance Monitor interview questions