Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database load distribution into a two node active/active cluster? Expand / Collapse
Posted Thursday, April 3, 2008 3:27 PM


Group: General Forum Members
Last Login: Monday, April 11, 2016 10:33 PM
Points: 23, Visits: 189
- SQL Server 2000 running on one host which houses 44 user databases.
- Moving to a two node active/active cluster setup.

How does one determine the specific databases that need to end up on VirtualServerA vs VirtualServerB (active/active) based on resource consumption of each database as they presently sit? How can one accurately record the CPU, memory and I/O consumption of each database in order to determine which database will end up on each virtual node in order to evenly distribute the load?

Post #479588
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse