To get an accurate view of SQL Server performance using SQL Server Activity Monitor without affecting overall system performance, how often should the server be polled?
A) 10 times/second
B) 1 time/second
C) 1 time/10 seconds
D) 10 times/minute
Correct Answer:
Verified
Q2: A data collector set is a collection
Q3: Which of the following is true about
Q4: Which type of message is generated automatically
Q5: Where are server-scoped dynamic management views stored?
A)master
Q6: What permission must a user have to
Q8: When is the ideal time to measure
Q9: For which type of event are notifications
Q10: Which section of Activity Monitor should you
Q11: How must the recipient of a notification
Q12: Ideally, database administrators will monitor SQL Server
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents