Re: What are the Best Practices for CIM Performance?
CIM Application performance relates directly to the performance of the database, network, and environment it is running in. To ensure CIM performance is optimal, the following recommendations are suggested:
CIM should be configured with separate database users for online application GUI use and offline database use for backend job processing. This allows the online users to be set up with the highest priority in tactical workload groups for online GUI use while the offline user can be in the medium workload group to process jobs.
Monitor Database Health (i.e. disk space, spool space, etc.)
Regularly collect Stats as recommended in the CIM Object Processing Guide"Statistics Collection" section
Use a database canary query to monitor database performance and compare to the performance of the CIM application (See Knowledge Article KCS005544 for more information)
Check the CIM Release Definition when upgrading to get any up-to-date performance recommendations (This document can be found on the Installation DVD in the Release Notes folder and via T@YS documentation links)
Regularly check to find the longest running CIM queries in the environment and execute Explain Plans to ensure they are executing to the best performance as possible.
Monitor the network connectivity at the site for connections between clients/servers and server/database.
Monitor the Application Server (i.e. errors, memory usage, disk space)