External views provide read-only access to the database and are optimized to not interfere with other Carbon Black App Control Server tasks. The database server is a shared resource, however, and overall performance of the Carbon Black App Control Server might be affected by extensive querying of external views.
Consider the following general suggestions:
- Avoid running queries that take more than two minutes to complete.
- Limit total time spent querying the external database to no more than 5% of total time (for example, a few minutes each hour).
- If possible, run queries at a time of day when Carbon Black App Control Agents are not very active, especially avoiding times when agents are initializing.
Contact VMware Carbon Black Support for assistance with performance issues.