Microsoft
MB7-700 · Question #93
The number of users in your company increases dramatically and you start receiving complaints about continuous locks when working with the database. Which instruments do you use to analyze the…
The correct answer is A. SQL Server Session Monitor B. SQL Server Management Studio Activity Monitor D. Client Monitor. See the full explanation below for the reasoning.
Question
The number of users in your company increases dramatically and you start receiving complaints about continuous locks when working with the database. Which instruments do you use to analyze the database and detect the activities which cause locking, considering that the database resides on Microsoft SQL Server? Choose the 3 that apply.
Options
- ASQL Server Session Monitor
- BSQL Server Management Studio Activity Monitor
- CSQL Server Query Analyzer
- DClient Monitor
How the community answered
(19 responses)- A84% (16)
- C16% (3)
Community Discussion
No community discussion yet for this question.