What are the SQL Database System Requirements?
For the POC Phase:
Microsoft SQL server (The Admin Portal DB can be on the same instance and/or SQL server with other DBs).
Only SQL full versions supported.
- The DB doesn’t require a separate SQL server. It can be collocated in an existing instance/server alongside other databases.
- Full text and syntax search should be enabled on the instance.
For Production:
- Hardware requirements should be in compliance with minimal/recommended hardware requirements, published by Microsoft.
Recommended configuration:
- Win 2016 or Higher Standard Edition/2016 Ent., 4CPU, 12GB ram, 10G disk space.
- HDD/SSD with R/W speed of at least 50MB/s.
- One server supports up to ~100K users
- Use SQL mirroring/Clustering for HA, SphereShield supports SQL Always on
- Only SQL full versions are supported, Express isn’t supported by our product.
- The DB doesn’t require a separate SQL server. It can be collocated in an existing instance/server alongside other databases.
- Full text and syntax search should be enabled on the instance.