Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database Engine Tuning Advisor

Author  Topic 

timgaunt
Posting Yak Master

115 Posts

Posted - 2007-05-31 : 05:19:51
Hi,

If I run a tuning trace through the Database Engine Tuning Advisor that contains INSERT, UPDATE and DELETE statements. In the past I've not been too concerned about duplicate data as the tuning would be done on test data but in this case the databases are more mission critical.

How does the Database Engine Tuning Advisor use the trace file? Does it run all the scripts against the database -and so inserting data etc? Or does it merely simulate the script?

TIA

Tim

----------------------------
I've finally started blogging (all be it badly!)

Check it out:
http://blogs.thesitedoctor.co.uk/tim/
   

- Advertisement -