Trace Line Database

A database with the name Trace-Trace Line is automatically created the first time you save your trace line in the configuration tool. See Trace Line Setup. If such a database already exists, the existing database will be used.

The file location and collation will be the same as for the Trace database created at install. The size attributes of the database default to the following:

  • Data

    Initial size 10 240 MB (10GB)

    Growth 1 024 MB (1GB)

  • Log

    Initial size 1 025 MB (1 GB)

    Growth 512 MB (0.5 GB)

The final size of the database depends both on the number of transactions in the M3 stock transaction table (MITTRA) and how the processes in your environment are designed.

As an example, a database created for tracing an environment with 22 000 000 MITTRA records grew to 30 GB, using the Simple recovery model. You can override create database step by manually creating the database before you save your trace line.

Note: 

  • When the Use database default checkbox is selected, predefined values are not utilised. Instead the data file size will be forced to the size defined by the SQL Server instance. As this usually results in an small database it is not recommended in a production set-up.

  • It is recommended to use the Simple recovery model.

    Using the Full recovery model will cause the log file to consume large part of the disk space during initial load. There is no need for Full recovery during daily run as a recovery can be done using the latest backup and reload from the source system.

  • The database name must follow the Trace-Trace Line naming convention. For example, Trace-M3TE123Test.

  • The collation for all databases must be the same as the Trace database.