Performance vs sp_addlinkedserver

  • Hi

    I have a stored procedure in a database on server1 

    I need to insert a record in a table on server2 with the stored procedure on server1

    I know that I need to link my SQL server to do that

    I jus want to know if the performance of my SQL Server will drop if

    I link two server. 

    Thanks

    Pascal Lebel

  • You will have a performance drop since it needs to communicate with another server.

    How large the drop will be depends on the amount of data & network latency.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply