We have around 15 linked servers in each of 2 servers and application is querying the views and stored procedures using these linked servers.
I would like to know
Is there a way to find from SQL(2008) Side, how many linked servers are being used and how many are not.. as application team want us to remove the unnecessary linked servers.
Is there any post/document which gives us more information on how to troubleshoot Linked server issues.
are there any DMV's or any Views where the historical information of Linked servers is maintained.