Whats the advantage of linking Servers?

[01310564]

We have just bought a new SQL server because our current server is getting hammered. I have two ideas of how to impliment this server, I can either transfer the most commonly used database onto the new server or i can link the new server to the old one. What i want to know is what sort of preformance i will get out of linking the server compared to running it as a separate server?

Cheers Hugh

 

[nigelrivett]

Running things on a linked server will cause distributed transactions, may run things on the old server anyway and if not cause a lot of problems due to having to transfer data to process.

Linked servers should be used with caution - it's very different to accessing a local database.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[jdgonzalez]

What are the differences?