Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, April 3, 2008 3:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:03 PM
Points: 23, Visits: 172
- 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