Single logical SQL Server possible from multiple physical servers?

Posted by TuffyIsHere on Stack Overflow See other posts from Stack Overflow or by TuffyIsHere
Published on 2011-03-20T02:38:34Z Indexed on 2011/03/20 8:10 UTC
Read the original article Hit count: 183

Hi,

With Microsoft SQL Server 2005, is it possible to combine the processing power of multiple physical servers into a single logical sql server? Is it possible on SQL Server 2008?

I'm thinking, if the database files were located on a SAN and somehow one of the sql servers acted as a kind of master, then processing could be spread out over multiple physical servers, for instance even allowing simultaneous updates where there was no overlap, and in the case of read-only queries on unlocked tables no limit.

We have an application that is limited by the speed of our sql server, and probably stuck with server 2005 for now. Is the only option to get a single more powerful physical server?

Sorry I'm not an expert, I'm not sure if the question is a stupid one.

TIA

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about sql-server-2008