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.