N-Tier objects / SQL Server / Win2k Cluster
Anybody have any experience with the failover of a SQL Server Cluster?
We are going to be doing some testing, just wanted to know what kind of results
I should expect.
On a similar note.. If some of the objects were installed on the same machine
as the SQL database, and were also installed on the failover machine in the
cluster, would calling objects still function? (ie, would they be able to
'call' the objects on the down machine, but the failover box would respond.)
(The design choice to install the data access components directly on the
SQL server was made due to the performance gains to be had. Scalability,
and high load performance may become an issue as SQL Server and the components
compete for resources. Not my decision, though.)
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center