Databases Reference
In-Depth Information
11. After executing this T-SQL statement, it's time to stop the trace that is
currently running by pressing the Stop button on the toolbar as shown in
the following screenshot:
12. Open Database Engine Tuning Advisor tool from Start | All Program | SQL Server
2012 | Performance Tool | Database Engine Tuning Advisor. Enter the Session
name as AdventureWorks2012WorkloadFile. In the Workload section, select the
File radio button and select the .trc file that we have saved in D drive. Select
Adventureworks2012 database from the drop-down menu besides Database
for workload analysis . Finally, your General tab should look similar to the
following screenshot:
13. Now, in the Tuning Options tab, select the Indexes radio button and enable the
Include filter index checkbox. The Tuning Options screen should look similar to
the following screenshot:
 
Search WWH ::




Custom Search