3

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

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

  2. Is there any post/document which gives us more information on how to troubleshoot Linked server issues.

  3. are there any DMV's or any Views where the historical information of Linked servers is maintained.

0

Are there any DMVs where linked server info is maintained
select * from sys.servers gives info about what are the linked servers configured .please see below msdn link for more details on usage
https://msdn.microsoft.com/en-IN/library/ms178530.aspx

Is there any post/document which gives us more information on how to troubleshoot Linked server issues.
This seems like a generalized question,depending on error message,my basic analysis would start from access issues ,sql error log...If you want to troubleshoot performance issues with linked servers there are many links in SO as well as online to start with.

http://thomaslarock.com/2013/05/top-3-performance-killers-for-linked-server-queries/

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.

This has been already answered here by Mr denny. https://dba.stackexchange.com/a/5520/31995

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.