Does DTA execute Update/Insert queries?

Last Post 26 Jun 2012 12:58 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

26 Jun 2012 06:38 AM
I have many Update/Insert SP and queries in SQL Profiler log using as Workload.

Can I run Tunning Advisor on production database, does it make any change to data?

Does running running advisor on production DB has any performance impact?
New Member
New Member

26 Jun 2012 12:58 PM
No it does not make changes to the data but it can have a performance impact on a production server depending on the workload youare attempting to tune and the current workload. I personally have not seen much success with the DTA. In fact I have seen it cause more troubles than it solved. I would recomend using a tool to p*** your trace files to show you which ones are using the most resources and address those first. HEre is one free tool that can do that:

Acceptable Use Policy