Crystal Report perfromance degradation seen after migrating a Pervasive.SQl - based application from server-client configuration to a Citrix environment.
Posted on 2008-11-12
After a recent acquisition, we migrated a pervasive.SQl - based application called FPA (Forest Products Accounting) from its existing server - client configuration to our Citrix based environment. We installed the Pervasive client on two load-balanced Citrix servers (Windows Server 2003) and we installed the Pervasive server engine on a separate server at the same site (also Windows Server 2003). Since the migration, users have reported significant degradation in performance when loading reports (the app uses Crystal Reports). I have monitored all three servers during operation and have noticed no significant spikes in resources while users are loading large reports. The vendor suggested configuring the micrkernal on the Pervasive server to not use local microkernal engine. This has made no positive impact. I am thinking this configuration change should be made on the Citrix boxes as the engine does not reside on those. I am hesitant to make more changes. Figured I'd rech out.