|Reporting On||Up to 200 devices||Up to 500 devices||Up to 5000 devices||Up to 10000 devices|
|DB||MS SQL 2008 / 2012 / 2014 / 2016 (Express Supported)||MS SQL 2008 / 2012 / 2014 / 2016 (Express Supported)||MS SQL Standard/Enterprise 2008 / 2012 SP1 / 2014 / 2016||MS SQL Standard/Enterprise 2008 / 2012 SP1 / 2014 / 2016|
It is recommended to install full version of MS SQL for deployments of more than 500 users. MSSQL Express will be installed by default if customer supplied MSSQL is not available.
Please note the following if customer supplied MS SQL server is used:
- MS SQL can be installed on the Periscope host server on a separate server or on existing SQL server/clusters. Relevant database and network configuration will require to be supplied by customer, NB: MSDTC (DTC) is used for database communication
- For large or high activity sites it can be recommended that full version MSSQL is installed on the same server as Periscope
- The SQL instance collation must be SQL_Latin1_General_CP1_CI_AS
- Periscope software requires DB user permission to create new database, and read and write to the Periscope databases
Thanks for your feedback.