Question:
What are the requirements for the SQL database for Capsys.
Answer:
General rule of thumb is whatever the SQL defaults for Collation are is good enough for CAPSYS. But if one needs to be specified then the following has been used by CAPSYS in the Azure Cloud for years.
SQL_Latin1_General_CP1_CI_AS
Sizing depends on maximum number cases will reside inside CAPSYS at any given point in time as well as the level of Auditlog enabled per QSX and how much is kept vs purged off or saved off.
CAPSYS database is typically no greater than 5 GB
0 Comments