You must configure the secondary companion with sufficient resources to perform the work of both servers during failover. For example, if both the primary and secondary companions are configured for 250 user logins, during failover, the secondary companion has only half the number of potential user logins necessary. MONEY1 and PERSONNEL1 should both be configured for 500 user logins.
The sp_companion do_advisory option checks the configuration options on both the primary and the secondary companion to make sure a cluster operation (such as configuring an Adaptive Server as a secondary companion) will be successful. sp_companion do_advisory advises you of any configuration options you should change.
