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.
😎