SQL Server requirements for Promodag Reports Enterprise edition
Supported versions
Promodag Reports supports all editions of Microsoft SQL Server from SQL Server 2008 to SQL Server 2022.
SQL Server Express (2008 to 2022) may be used with Promodag Reports Enterprise edition; however, database size is limited depending on the version (10 GB for SQL Server 2008 R2/2022 Express and 4 GB for SQL Server 2008 Express).
Recommendations
We recommend the following specifications:
- Use, if possible, a dedicated SQL server.
- The more powerful the machine is, the better, especially if you plan to store a large database (100 GB or more). For a 'basic' configuration (up to 50 GB), plan to use a computer or a VM with 4 GB of RAM, 4 Cores at 2.5 GHZ or greater, a recent operating system, and a generous amount of disk space. Keep at least the equivalent of the database size as free disk space: if you estimate that your DB will ultimately reach 50 GB in size, then go for 100 GB. This may be required when a database conversion is needed. To estimate the growth of your SQL database, see Estimating the database size growth.
- Apply the 'Simple' recovery model to your Promodag Reports database.
- Do not apply any size restriction to the TEMPDB system database.
- Allow the data files to grow automatically, but set a limit on their growth by specifying a maximum data file size that leaves some available space on the hard disk.
See also: Using Promodag Reports and Microsoft SQL Server.
Permissions
The Promodag account must have been granted the db_owner role on the Promodag Reports database. It must also have the public and db_datareader roles on the TEMPDB database.
The ability to create databases requires specific SQL permissions (CREATE DATABASE).
Data retention strategies
We recommend that you use one of the following data retention strategies:
- Create a new SQL database every 1 or 2 years on 1st January, and archive the previous one.
- Keep the same database, but regularly purge old data so that only the last 90, 180, 365 days are retained.