Tuning with Database Engine Tuning Advisor - Microsoft SQL Server 2012 Performance Tuning - page 41

How to do it...

Now here is the query we want to execute and tune if possible:

SELECT
P.ProductID
,P.ProductModelID
FROM
ProductDemo AS P
JOIN
ProductModelDemo AS PM
ON
P.ProductModelID=PM.ProductModelID
WHERE
P.ProductID=680
GO

Here is the list of steps that we should follow in order to analyze the given query in DTA.

1. Write down the query in SSMS. Click on Start | All Program | Microsoft SQL Server

2012 | SQL Server Management Studio (SSMS) and try to execute it by pressing the
F5 key or the execute button from standard toolbar.

2. Select the query in SSMS and right-click on it.

3. Select the option Analyze Query in Database Engine Tuning Advisor from the

pop up menu: