SizeToSplitDatabaseOn - System Parameter
The SizeToSplitDatabaseOn System Parameter determines how large the online Log Database is allowed to get, before a new online Log Database is created. 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 (default proposition in the Install and Update Tool).
Note: If you log more than you delete, you will eventually fill the Log Database until it either gets slow, or out of disk space.
Nodinite does not have a problem with large volumes of logged data since we create new databases as the old ones gets to large. You will eventually get into the problem, or at least the administration with having disk space for all that you choose to keep. Nodinite has a very clever solution to help you keep what matters and that is by deleting events based on content (actually the datatype for the message, which we happen to call a MessageType).
|System Parameter Name||Data Type||Values/Example||Comment|
|SizeToSplitDatabaseOn||integer||50 (Gb)||Default =
This feature was introduced with Nodinite version 3
Changing a value for any of the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.
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.