You are the database administrator for AIOTestKing.com. You manage a SQL Server 2005 database named Sales. You are given a SQL Server Profiler sample workload with queries to the Sales database on a typical day. You need to evaluate the effectiveness of current indexing and identify changes that would be appropriate. What should you do first?
A.
Create a query with the five stored procedures that are used the most frequently. Then click the Analyze Query in Database Engine Tuning Advisor button.
B.
Use the Database Engine Tuning Advisor (DTA) with the sample workload.
C.
Use the Index Tuning Wizard with the sample workload.
D.
Use SQL Server Profiler to run the sample workload.
Explanation:
To build a recommendation of the optimal set of indexes, indexed views, or partitions for your databases, Database Engine Tuning Advisor requires a workload. A workload consists of a Transact-SQL script or a SQL Server Profiler trace saved to a file or table. If you are using a SQL Server Profiler trace file or table, they must contain Transact-SQL batch or remote procedure call (RPC) event classes, and the Event Class and Text data columns.