Operating systems | Windows Server 2008 R2 or above Windows 7 or above | |
|---|---|---|
| Microsoft SQL Server | SQL Server 2008 or above | |
Individual user/ Small team |
| 2 Core (2.8GHz or more suggested), 4GB Ram Ability to use SQL Server Express edition. Read More |
Multiple small teams/ Large team |
| 8 Core (2.8GHz or more suggested) 10 Ram |
Multiple large teams/ Department/Division |
| 16 Core (2.8GHz or more suggested) 16 Ram Ability to scale and resize hardware specifications depending the usage and the number of concurrent users. |
At least 100GB of space (requires much more spaces in case of BIM models as one big model can consume up to 1G)
For SQL server editions and limitations Read More
SQL Server Express
SQL Server Express may only be used at no charge for development and testing, as well as for “micro workloads” such as mobile or web apps with minimal relational database requirements. The free license does not apply to instances running on virtual machines
Database Filestream
Filestream is a required feature that must be enabled on the Database Instance that CostOS will use.
Filestream, as a feature, allows binary data to be saved to the filesystem instead of the database. This provides a performance enhancement, when used for large ammounts of data. Furthermore, Filestream protects data integrity because the file operations are performed as part of a transaction.
Filestream Data are still saved in tables, like traditional BLOB data types.
Normally, CostOS Server Installer will enable and configure this feature automatically. See more at Install and configure CostOS Application Database (Microsoft SQL Server)
| BOQ Items* | 3000 Items | 10000 Items | 50000 Items | 100000 Items |
|---|---|---|---|---|
| Size of SQL Server Data file | 32 MB | 92 MB | 436 MB | 858 MB |
| Size of SQL Server Log file | 16 MB | 42 MB | 290 MB | 290 MB |
* Each BOQ item contains 1 assign item as resource.