5) //
You are a database developer for your company's SQL Server 2000 database.  You update several stored procedures in the database that create new end-of-month reports for the sales department. The stored procedures contain complex queries that retrieve data from three or more tables.  All tables in the database have at least one index.

Users have reported that the new end-of-month reports are running much slower than the previous version of the reports.

You want to improve the performance of the reports. What should you do?

A.         Create a script that contains the Data Definition Language of each stored procedure. Use this script as a workload file for the Index Tuning Wizard.

B.         Capture the execution of each stored procedure in a SQL Profiler trace. Use the trace file as a workload file for the Index Tuning Wizard.

C.         Update the index statistics for the tables used in the stored procedures.

D.         Execute each stored procedure in SQL Query Analyzer, and use the Show Execution Plan option.

E.         Execute each stored procedure in SQL Query Analyzer, and use the Show Server Trace option.
---------------------------------------------------------------------------------------------------------------------------------------

Ans:E      Server Trace option Could anyone tell me why item E is correct? Thank you very much.

Could any experts give me some explaination with this question?
Thank you very much.