February 28, 2008 at 8:07 am
Good morning-
If I want to run the Tuning Advisor using a trace file, do I have to run it on the same server that the trace was taken from?
Thanks!
February 28, 2008 at 8:15 am
You can run from a client machine also. but you have to run against the server where the trace was taken from.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 8:21 am
Hi,
You can run on a separate server from source, which is the better option to minimize impact to your main server. Here is a good document for reference:
http://msdn2.microsoft.com/en-us/library/ms190389.aspx
Thanks,
Phillip Cox
MCITP - Database Administrator
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply