Use Database Engine Tuning Advisor on SQL 2008
Posted on 2014-01-16
To use DTA in SQL 2008, I need to generate a workload using SQL Server Profiler. Normally, what kinds of event should I capture on the file. How long should I take on the production server and will it affect the performance ?
Is it enough to capture "SQL:Batch Completed" & "RPC:Completed" ? Or I need to include much more detail "sp:StmCompleted" and "sp:StmStarting" as well.
After capturing the file, if I load the file on other testing sql server and run the DTA, will the result reflect the real situation on the production sql server ?