Specify Workload

Use the Specify Workload dialog box to specify the name of the workload file to use as input for tuning.

Options

My workload file

Specify the location of the workload file. The file must be in one of these formats: .trc (SQL Profiler trace file), .sql (SQL file), or .log (Microsoft® SQL Server™ 2000 version 6.5 trace file).

SQL Server table

Open the Connect to SQL Server and Source Table dialog boxes to specify the database table containing the workload for tuning.

Query Analyzer selection

Select to analyze a single query or batch in SQL Query Analyzer. Only members of the sysadmin fixed server role can perform index analysis using SQL Query Analyzer.

Advanced Options

Click the Advanced Options dialog box to view or change the index tuning parameters.