Database Reference
In-Depth Information
Figure 10-12.
Database tuning engine in progress
The processing runs for about 15 minutes on my machine. Then it generates output, shown in Figure
10-13
.
Figure 10-13.
Recommendation for a manual statistic
After running all the queries through the Database Engine Tuning Advisor, the advisor came up with a suggestion
for a new index for the
Product
table that would improve the performance the query. Now I just need to save that to a
T-SQL file so that I can edit the name prior to applying it to my database.
Tuning from the Procedure Cache
Introduced in SQL Server 2012 is the ability to use the query plans that are stored in the cache as a source for tuning
recommendations. The process is simple. There's just one more choice on the General page that lets you choose the
plan cache as a source for the tuning effort, as shown in Figure
10-14
.
Figure 10-14.
Selecting Plan Cache as the source for the DTA
