Database load distribution into a two node active/active cluster?

  • - 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply