We've recently implemented a new Goldmine CRM and the reporting features are slow.
The setup is all on the same LAN, and involves 2 seperate servers; one for the GM application and reporting services, and another SQL 2005 Enterprise server which holds the database.
When running a report, the CPU holds at about 25%, and the application hangs for few - many minutes. The processes are SVCHOST.exe, which I drilled down to RpcSs.
When I test going to http://localhost/reports
, the response is the same, which leads me to believe the problem is not really related to Goldmine, but maybe something in IIS, Reporting Services, the SQL server, or the connection between the app server and SQL server.
Any ideas on good steps to troubleshoot this further, or maybe ideas on configuration changes I can make to speed this up?