June 23, 2014 at 8:01 am
Hi Team,
Created a user defined template in sql profiler, while trying to open the trace file in tuning advisor getting below error.
Is there any alternate way to open the trace files in Tuning adivisor.
June 23, 2014 at 8:04 am
There's no error attached at the moment...
June 23, 2014 at 8:10 am
Hi,
Gettting below error.
You don't have permission to open this file.
Contact the file owner or an administrator to obtain permission
June 23, 2014 at 8:15 am
Did you stop the trace before trying to open the file?
June 23, 2014 at 8:25 am
Trace file which am trying to read is stopped, and another trace file is running currently.
June 23, 2014 at 8:28 am
Either the file is locked, or the user you're attempting to run the DTA with doesn't have access to the file location.
"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
June 23, 2014 at 9:15 am
presuming you have the rights, try right clicking on DTA and run as administrator.
---------------------------------------------------------------------
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply