The minimum system requirements for SupportCenter Plus:
Inbound Requests Per Day
Hard Disk Type
10x - Less than 100
1.7GHz to 2.4GHz
100x - Upto 1000
2TB - SSD
2.4GHz to 3.0GHz
12MB to 20MB Cache
1000x- More than 1000
2TB#/3TB* - SSD
* - When bundled PostgreSQL is configured as a database
Mentioned below are the minimum requirements to run SupportCenter Plus on an MSSQL setup. This requirement is applicable only to the SupportCenter Plus -related database.
2.4GHz to 3.0 GHz
For optimum usage of MSSQL Database,
Configure File Autogrowth.
Enable Read Committed Snapshot Isolation (RCSI) and Database Maintenance Schedule.
To enable database maintenance schedule, go to Admin > General Settings > Performance Settings (or) ESM Directory > Performance Settings. Click here, to learn more.
To learn more about MSSQL best practices, click here.
All MSSQL databases usually have lock issues, which may affect an application’s optimal performance. To avoid such performance issues in SupportCenter Plus, enable the read committed snapshot isolation (RCSI) by following these steps:
ALTER DATABASE <db_name> SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE <db_name> SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE
ALTER DATABASE <db_name> SET ONLINE
Simultaneous user-querying of the database will be possible without any delay or disruption (although the load on the application might exceed the usual limits).
User querying records will be maintained in a separate tempdb, which will not be affected by other user queries occurring in parallel or subsequently.
Database tables will be updated only after a transaction reaches completion.
We strongly recommend that you have an initial database capacity of at least 5GB and extend it periodically in advance by monitoring the current database file size to avoid an auto-growth event being triggered unnecessarily. This will ensure optimum application performance and smooth data processing.
File Autogrowth for database files can be configured as well. To learn more, click here.
Run the following query to create a database:
CREATE DATABASE <dbname>
Find the current database size by running the query below
select (size*8)/(1024*1024) from sys.master_files where DB_NAME(database_id)='supportcenter' and physical_name like '%.mdf%';
Run the following query to add 5 GB to the current database size
ALTER DATABASE supportcenter
(NAME = <dbname>,
SIZE = <currentdbsize+5GB>);
Default autogrowth settings in the SQL Server engine may lead to disk fragmentation and performance issues. These values are set at 1 MB and 10 percent for Data File and Log File, respectively. We recommend that you configure these as fixed values and not in percentage.
To ensure optimum application performance, we strongly recommend that the Data File and Log File autogrowth values are configured as 256 MB and 128 MB, respectively.
Follow these steps to configure File Autogrowth
ALTER DATABASE <db_name>
MODIFY FILE ( NAME = N'<db_name>', FILEGROWTH = 256MB )
ALTER DATABASE <db_name>
MODIFY FILE (NAME = N'<db_name>_log', FILEGROWTH = 128MB )
Since PostgreSQL 9.2 requires users to modify kernel resources to allot required resources for Postgres server,
i. Add the the below mentioned entry in /etc/sysctl.conf
ii. Execute sudo sysctl -p /etc/sysctl.conf to reload the configured change.
Note: This is only applicable for Linux OS installations that use bundled Postgres.
Any antivirus software, such as Symantec, running on the same system as SupportCenter Plus can affect the application's performance. Therefore, to ensure application performance, exempt the following items from antivirus scanning:
pgsql.exe process and PostgreSQL folder for the PGSQL database
Log folders for both MSSQL and PGSQL databases