- 2 minutes to read

SizeToSplitDatabaseOn - System Parameter

The SizeToSplitDatabaseOn System Parameter determines the maximum allowed size for the online Log Database before trying to spawn a new online Log Database. The Logging Service can create new Log Databases as they grow either too old or too large.

We at Nodinite recommend that you set a large number like 50GB -> 100 GB depending on the environment (this is also the default proposition in the Nodinite Install and Update Tool).

Important

If you log more data than you delete, you will eventually fill the Log Database and run out of disk space.

Nodinite has no problem with large volumes of logged data since the system creates a new database as the old one gets too large (or too old).

System Parameter Name Data Type Values/Example Comment
SizeToSplitDatabaseOn integer 50 (Gb) Default = 50 (50 Gigabyte)

This feature comes with Nodinite version 3.

Important

You must restart the Logging Service for changes to take effect.

flowchart LR id1[(NodiniteLog_Prod_20150517</br>Archive</br>17 GB)] id2[(NodiniteLog_Prod_20160229</br>Archive</br>37 GB)] id3[(NodiniteLog_Prod_202200409</br>Online</br>2 GB)] id1 -.- id2 id2 -.- id3 ro[fal:fa-envelope New Log Events ] --> id3 ro1(fal:fa-trash-can Delete old data by Message Type) --> id1 ro1 --> id2 ro1 --> id3

Excessive Logging eventually leads to a plethora of problems. Nodinite removes historical data from the Log Databases according to user settings and some System Parameters to mitigate this situation.

New Log Events inserts into the online Log Database. Old data get removed according to the following System Parameters:

Log Events usually make the Nodinite Log Database grow. Other parts like data from the Monitoring and the Log Audited user actions get removed according to other System Parameters.


Frequently asked questions

Additional solutions to common problems and the Nodinite System Parameters FAQ exist in the Troubleshooting user guide.

How do I change the value?

Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.

Can I manually create Log Databases in advance with planned timespans for usage?

Yes, we provide all Nodinite databases as a DACPAC package, and you can follow the 'How do I create Log Databases manually?' guide to learn more about this topic.


Next Step

Message Types
DaysToSplitDatabaseOn
Administration