Microsoft
70-432 · Question #27
You are the administrator of a SQL Server 2008 instance containing a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command…
The correct answer is A. You should use Dynamic Management Views. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance containing a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use?
Options
- AYou should use Dynamic Management Views
- BYou should use SQL Server Resource Governor
- CYou should use SQL Server Profiler
- DYou should use Windows System Monitor
How the community answered
(33 responses)- A82% (27)
- B3% (1)
- C3% (1)
- D12% (4)
Community Discussion
No community discussion yet for this question.