August 27, 2014 at 1:12 pm
Hello all
I am performing analysis of linked servers across 2000-2008R2 and need to find/build a list of linked servers that are truly active. For the sake of the post let's define 'active' have executed a distributed query in the last 5 days.
I have been scanning the DMVs without much success. Perhaps I must look more closely at MSDTC?
The end result would be to cleanup 300+ linked servers across 40+ SQL Servers.
TIA
Rocky
August 27, 2014 at 1:33 pm
rocky.paiano (8/27/2014)
Hello allI am performing analysis of linked servers across 2000-2008R2 and need to find/build a list of linked servers that are truly active. For the sake of the post let's define 'active' have executed a distributed query in the last 5 days.
I have been scanning the DMVs without much success. Perhaps I must look more closely at MSDTC?
The end result would be to cleanup 300+ linked servers across 40+ SQL Servers.
TIA
Rocky
Quick thought, look into sys.dm_tran_* where request_session_id = -2, have to look into this more (grey cell memory corruption) but somehow that was the first thing coming to mind.
😎
August 28, 2014 at 9:23 am
Thanks Eirikur
I think the gateway is sys.dm_os_hosts. Any further insights from the community on dm_os_hosts and distributed queries?
September 5, 2014 at 9:06 am
ttt
September 12, 2014 at 7:17 am
wow, is this not possible?? Or am I asking is the wrong place. can't imagine this issue has not been addressed before!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply