Memory usage by the Embedded Database of Symantec Protection Center (SPC) for Symantec Endpoint Protection Small Business Edition (SEP SBE) 12.0 is consistently at several hundred megabytes even on systems with very few clients. Restarting the Symantec Embedded Database service only causes memory usage to drop while the service starts back up.
The Symantec Embedded Database service is the database service used by the SPC for storing all data about the SEP environment - including Site information, Group structure, Client logs, Policies, and packages. This service utilizes the Sybase Adaptive Server Anywhere (ASA) database engine. ASA will reserve between 128 MB and 256 MB of memory for caching. Additional memory will be used to house actively accessed data and for overhead of the ASA database engine.
The amount of memory used by the Symantec Embedded Database serivce will depend on the number of active SEP clients, the number or Client Groups, and the number of Policies in use in the Site.
This behavior is as designed.
If the Symantec Embedded Database service is using more than the minimum or recommended system requirements for memory, steps should be taken to determine if the usage is due to higher than normal client load, or if there are other issues affecting the memory usage.
If memory usage of the Symantec Embedded Database is within the recommended system requirements for memory, and the performance of the system hosting the SPC is not satisfactory, It is recommended to ensure the SPC is not installed to a system with the following:
- Other database-related applications such as Microsoft SQL Server, Oracle, PostgreSQL, MySQL or other instances of ASA
- Application servers such as Microsoft IIS, Tomcat/Apache Server, Quickbooks Server, or Microsoft Exchange Server which require large amounts of disk I/O and network bandwidth