The BMS Server 2.0 allows historical data recording on a Microsoft SQL Server database. You can either use the Microsoft SQL Server Express instance that is installed along with the BMS Server 2.0 (named NETX_SERVER_SQL) or connect to any other SQL Server instace locally or remotely. Use the config parameters in the BMS Studio under Server / System configuration / XDB.
The Microsoft SQL Server Express edition allows up to 10 GB database size (corresponding to roughly 90 million records), exceeding that size is not possible, even if your disk has space left.
When the BMS Server starts the workspace it checks if the database of the name NETX_<workspace-name> already exists. If that is not the case the database will be created automatically.
In order to avoid the database grow full too quickly, consider following points:
- Use as few historical datapoints as possible.
- Periodically polled datapoints flagged as historical will lead to a constant growth of the database because each read value creates a record in the database. Make estimate of the number of records per day just by multiplication, and sum up these numbers for each datapoint. Compare the result with the rough limit of 90 million records to get an estimate of number of days fitting in the database.
The BMS Server 2.0 provides some means to monitor and control the database size:
- In the BMS Server's item tree there is NETx\Server\Database\Size indicating the current size in MB. You might want to observe that value or even use it as a trigger for an event to notify the user.
- In the BMS Studio under Server / System configuration / XDB / Max data age defines the number of days the historical records should be kept in the database. Older records will be deleted automatically.
- In the BMS Studio, if the Server / System configuration / XDB / Auto-purge near-full database option is activated, the BMS Server deletes the oldest 20 % of the data if the database is 90 % full. This applies only to SQL Server Express editions!