I am new to Linked Servers and i have a few questions that would help me understand this better.
1> I have set up a linked server from Server A to Server B.
A job is fired from server A to server B every 2 mins. Is there a way of tracking on Server B which server(s) have Server B as a linked server and what activity is being performed.
2> If the job is an update query that updates 50 records every 2 mins would this have an impact on the performance on either of these servers.
3> What bothers me is that i know that a job is running every 2 mins but i do not see an event in either the SQL Server logs or on the windows logs . Maybe i am just not looking in the right place ?