Evil Kraig F (2/5/2014)
Your best bet is to analyze your optimization plans, determine what your access methods can be, and then reviewing your existing tables. Sometimes simply including a single column into an existing index is the answer. Sometimes rebuilding the table from scratch with a clustered index that isn't the PK is.
Agreed.
DTA is a tool that can be helpful under the direction of an experienced person who can analyze the output, knows the data and usage patterns, and who understands the execution plans on the system.
In the wrong hands, DTA can be instrumental in causing bigger performance problems.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events