How much memory on the hard disk is taken up when logging to SQL Server?
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
<< View All FAQs<< View All Troubleshooting Topics