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
sql-server-2005
|sql-server-2008
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