September 5, 2013 at 5:26 am
I uploaded a trace file to DTA, the file size is 4GB & i need to run it against all Databases.
What will happen if i stop it with recommendations in between??
or should i wait for the completion?? please suggest
************************************
Every Dog has a Tail !!!!! :-D
September 5, 2013 at 6:47 am
The most honest suggestion I can make, don't run it at all. The DTA recommendations are usually weak, at best. Sometimes they are down right frighteningly dangerous. I am a strong advocate against its use.
However, if you do stop it in the middle of a run, you will leave behind artifacts, primarily sets of statistics as it tries things out. By and large they won't impact your machines adversely, too much. But, those statistics will be maintained as your data changes, adding somewhat to the overhead of your system. If your systems are very large, you may see the negative impact.
But, since you should only be running this against a test or development system, NEVER against production, it shouldn't be that big a deal.
You're not running it against production are you?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2013 at 7:14 am
If you must use DTA, don't run it against production, don't set it to automatically implement recommendations and don't set it to remove indexes.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply