We have a tonne of linked servers on our database server that we would like to clean up.
Is it possible to determine the last date a linked server was used? e.g. the last time a query was performed through it.
You'll have to setup SQL Profiler to monitor for queries which use the linked server. There's no DMV that you can easily monitor for usage.
You might be able to look at the dmv sys.dm_exec_sql_text to look at where the linked server name was last used in a sql statement.
Lots of caveats for this:
Note: If you do tweak it and get it working, please change the above sql