we have one SRM server (Sepctrum 10.2.1) collecting the data from multiple landscapes. Current size of the DB is 33 GB and running every report takes really long time. Can we redistribute the load to 2 SRMs? and if yes, then how to specify which landscape provides data to which SRM?
Please refer to Business Objects Integration - CA Spectrum - 10.2 and 10.2.1
Starting from Spectrum 10.0 release, you can use the Multi-Tenancy Support feature to generate reports for multiple landscapes data collected by multiple SRM servers. The main purpose of this feature is reducing the number of CABI machines and allowing a single CABI machine to generate reports for multiple SRMs. Using this feature you can connect multiple SRM servers to a single CABI to monitor entire network infrastructure easily and efficiently.
Be aware, that this is with the old BOXI CABI not the Jaspersoft CABI.
Engineering is working on a way to do that with the Jaspersoft CABI, but it is not ready yet.