Overview
When upgrading to version 6.6.4 of the Pivotal Business Server, you may encounter performance issues due to changes in SQL query execution that affect execution plan caching. This can lead to increased query times. To resolve this, a patch is available that includes an updated rda.dll file to restore query performance.
Information
To apply the patch and restore SQL query performance in Pivotal Business Server version 6.6.4.*, follow these steps:
- Stop the Pivotal Business Server: Ensure that the server is completely stopped before proceeding.
- Backup the existing
rda.dllfile: Navigate to the directory where the currentrda.dllfile is located and create a backup copy. - Replace the
rda.dllfile: Extract the updatedrda.dllfile from the provided patch zip file (PBS_6.6.4.8_Patch_26378b_SQLPlanCacheFix) and replace the existing file with this new version..zip - Restart the Pivotal Business Server: Once the new
rda.dllfile is in place, restart the server to apply the changes.
After applying the patch, test the system to ensure that query performance has been restored to expected levels.
Frequently Asked Questions
- What is the cause of the performance issue in version 6.6.4?
- The performance issue is caused by changes in the way SQL queries are executed, which affected execution plan caching and led to increased query times.
- How do I apply the patch to fix the performance issue?
- To apply the patch, stop the Pivotal Business Server, backup the existing
rda.dllfile, replace it with the updated version from the patch, and restart the server. - What should I do if the performance issue persists after applying the patch?
- If the performance issue persists, ensure that the patch was applied correctly and that the server was restarted. If problems continue, contact Pivotal Support for further assistance.
Priyanka Bhotika
Comments