Database Engine Tuning Advisor

Question

Database Engine Tuning Advisor

pankaj.kuchaliya

SSC Eights!

Points: 944
More actions
September 15, 2010 at 12:27 am

#240287

Hi,
I have check the query in database engine tuning advisor, it display the recomendations.should i follow the given recomendations directly ?
Please help?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Not without testing and making sure the recommendations really help. Test them out one by one, implement the ones that do help.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

DTA will not help you if your queries are poor in the first place, such as the one stated in one of your other threads.

http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx

Clear Sky SQL
My Blog[/url]

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 3

Dave Ballantyne (9/15/2010)
DTA will not help you if your queries are poor in the first place, such as the one stated in one of your other threads.
http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx

suppose i have 5-6 tables and i have apply left outer join in it. then i check the performance in the DTA , if it display some recomendations then i should apply it or not.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

As I said

GilaMonster (9/15/2010)
Not without testing and making sure the recommendations really help. Test them out one by one, implement the ones that do help.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

steveb. SSC-Forever Points: 46733 More actions · Answer 5

setup a test db and then apply the recomendations one-by-one and test the performance gain you get and then see if you are happy.

no one can tell you whether or not you should follow DTA verbatim without knowing a lot more about your setup and testing it.

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 6

pankaj.kuchaliya (9/15/2010)
Dave Ballantyne (9/15/2010)
DTA will not help you if your queries are poor in the first place, such as the one stated in one of your other threads.
http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx
suppose i have 5-6 tables and i have apply left outer join in it. then i check the performance in the DTA , if it display some recomendations then i should apply it or not.

K , thanks for the reply.i will thorougly check each query without apply recomendations and with Recomendations.

thanks again.