Microsoft
70-432 · Question #29
You are the administrator of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify…
The correct answer is D. You should use the Activity Monitor tool in Microsoft SQL Server Management Studio. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use?
Options
- AYou should use the Database Engine Tuning Advisor tool
- BYou should use the Windows System Monitor tool
- CYou should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio
- DYou should use the Activity Monitor tool in Microsoft SQL Server Management Studio
How the community answered
(29 responses)- A7% (2)
- B3% (1)
- C14% (4)
- D76% (22)
Community Discussion
No community discussion yet for this question.