You are the administrator of your company network. And you’re in charge of a SQL Server 2008 instance which contains a large mission-critical database. And the database experiences a high volume of DML activity. Now you find that the applications which link to the database make response very slowly. In order to collect information about index fragmentation, new potential indexes and unused or sparingly used indexes, you have to develop a monitoring process to do this. So what should you use?
A.
You should use SQL Server Profiler.
B.
You should use the System Monitor tool.
C.
You should use dynamic management views.
D.
You should use Database Engine Tuning Advisor.