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
microsoftee
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?
gunneyk
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: http://www.scalesql.com/cleartrace/...nload.aspx


Acceptable Use Policy
---