You administer a remote SQL Server 2008 instance that contains a database named
InsightDB. The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively and triggers the population of
multiple tables.
Users of the application report that the application performance is poor. You suspect that the
performance issues are related to blocking.
You need to monitor the state of the instance at regular intervals without affecting the
application performance further.
Which tool should you use?
A.
SQL Server Profiler
B.
Windows System Monitor
C.
Dynamic Management Views
D.
SQL Server Resource Governor