December 3, 2008 at 11:07 am
For a transactional database what high-level clustering/load balancing/failover technology are available? And, what are different solutions?
--Thanks
December 3, 2008 at 1:17 pm
clustering does not provide load balancing only fail over.
what is it you are looking to do specifically
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 2:00 pm
we are in the development phase for the project where we use sql server 2005. It is a transactional database which has the capacity to audit, & reporting. these transactional databases are spread across 6 or more databases with few of them inter-related like audit database, & few functions of the databases are in different DB.
like DB1, DB2, DBAudit, ....
DB1 has one functionality
DB2 has one functionality
DB3 has one functionality & reporting capability (for all DB1, DB2, DB3)
DB4 is an audit databases for DB1, DB2, DB3.
we want to identity the best clustering solution & load balancing solution for these databases which would be installed in the same SQL Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply