January 15, 2015 at 7:29 pm
Hello,
if in another branch has linked server for our database server, is it possible find these queries?
Because I tried execute on our server where is linked server for next server, and there is not in activity monitor or somewhere, i cannot find, when was started remote query and if it has poor or good performance ...
thanks for help
January 15, 2015 at 7:40 pm
or is it possible who has our server like linked server?
January 16, 2015 at 4:58 am
Trace events on either machine should see the queries if you're capturing both rpc_completed and sqlbatch_completed.
"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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply