Open Automation Software
Moving Data From Anywhere to Anywhere
1-303-679-0898

Frequently Asked Questions – Data Logging

Data Logging

View the Database Security Login topic on how to setup security logins and access writes to create, open, and read and write to the database.

View the source of the problem under Configure-System Errors.

The complete history of errors can be viewed under C:Program Files (x86)Open Automation SoftwareOPC Systems.NETLog or the path that is set under Configure-Options-System Logging.

Either enable the SYSTEM account to have read and write access to the mapped drive and directory, or set the OAS Service LogOn to a user account, the same as the steps in setting the OAS Data Service LogOn, but set the LogOn for the OAS Service.

Either enable the SYSTEM account to have read and write access to the mapped drive and directory, or set the OAS Database Service LogOn to a user account, the same as the steps in setting the OAS Data Service LogOn, but set the LogOn for the OAS Database Service.

View the following video on how to setup security in the database engine:

Direct link: https://www.openautomationsoftware.com/videos/#troubleshoot-connection-login

Go to Configure-Options-Data Buffering and enable data buffering to disk.

View the following video on how to setup data logging so there is no data loss on a network or database engine failure:

Direct link: https://www.openautomationsoftware.com/videos/#data-buffering

Go to Configure-Options-History and Enable History Date Format.

Examples:

yyyy-MM-dd HH:mm:ss

MM/dd/yyyy HH:mm:ss

Use the following as the Database name:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)))

As example for a system with a computer name GWDESK and the Oracle database name OPCDb:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=GWDESK)(PORT = 1521)))(CONNECT_DATA=(SERVER= DEDICATED)(SERVICE_NAME=OPCDb)))

The following should be used as an aid in sizing database requirements.

The method used is to store 100 Tags each, of a few common data types for one hour at a 1 second continuous interval to separate tables. SQL Server 2005 Express was used to gather this information.

As always your final results may vary.

In SQL Server you can set the Database property under Options for Recovery model to Simple to reduce disk usage.

Boolean Data type table size

Rows: 3598

Reserved: 200 KB

Data: 152 KB

Index Size: 16 KB

Unused: 32 KB

Double data type table size

Rows: 3598

Reserved: 3272 KB

Data: 3200 KB

Index Size: 16 KB

Unused: 56 KB

Integer data type table size

Rows: 3598

Reserved: 1672 KB

Data: 1600 KB

Index Size: 16 KB

Unused: 56 KB

String data type table size (100 char / tag)

Rows: 3589

Reserved: 84752 KB

Data: 84552 KB

Index Size: 144 KB

Unused: 56 KB

SQL Server provides the ability to log multiple records in one call, so using SQL Server on a local or remote server is the best choice.

CSV files without a database are the smallest usage.

SQL Server and mySQL are very comparable.

Oracle uses approximately 4 times the disk space as SQL Server and mySQL.

In SQL Server you can set the Database property under Options for Recovery model to Simple to reduce disk usage.

Use the Windows Task Manager under Processes.  If you see that SQL Server is using up too much memory you can limit the amount of memory SQL server uses in the SSMS server properties under the memory section.