Performance Monitor Interview Questions | Snaprecruit.com
Performance Monitor Interview Questions | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
Performance Monitor interview questions
Performance Monitor interview questions
Back
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
Slow SELECT queries with high physical reads and low queue lengths demonstrates under performance of Disk read and write
Similar Interview Questions
Search for latest jobs
Find Jobs