I have two instances of SQL Server 2005 running on two separate dedicated servers (let's call them DB1 and DB2). At the moment DB1 is very busy and DB2 is mostly idle. Is it possible to configure the instance running on DB1 to utilize the processor on DB2?
For example, I connect to DB1 and execute "sp-heavy-going" and I would like DB1 to process this request using DB2's processor?
So far, I have looked at Linked Servers and it appears to distribute the CPU usage such that there is a 60% reduction in CPU usage on the linked server. e.g. When I execute the sp directly on DB1 the CPU usage jumps to around 75% average whereas when executed via DB2 which is has a link to DB1 the CPU usage on DB1 averages 30% and on DB2 it averages 50%.
Is Linked Server the way to go with this or is there a better way whereby the CPU usage on DB1 can be minimized further?
Darren