Max Size SQL Database

6 Posts
3 Users
0 Likes
40 Views
(@r.buisson@arcinfo.com)
Posts: 0
New Member Guest
 

Hello,

1 customer for Chemical process store data in one SQL database, at this time SQL database reach the size of 3,2Tb and will reach the size of 6Tb at nominal size.

 
Posted : 16/02/2017 4:32 pm
BO
 BO
(@b-olombelarcinfo-com)
Posts: 196
Reputable Member
 

Who said that we need a real external historian software 😀 ?!

 
Posted : 16/02/2017 4:52 pm
(@r.buisson@arcinfo.com)
Posts: 0
New Member Guest
 

when customer know that they do it's easier 😉

 
Posted : 16/02/2017 4:55 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Size is a point but, for me, not the most important.
The flow is the most important.

@Romain: Do you know the recording flow figure?

 
Posted : 17/02/2017 8:23 am
(@r.buisson@arcinfo.com)
Posts: 0
New Member Guest
 

You're right because our way to archive data is not very optimize and with some optimization same data will take less size.

I don't remenber exact flow, I think it's something like 500 records/s

 
Posted : 17/02/2017 2:34 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

I have checked the current DB figures with one of our customer in Asia having a big project.
DB size = 9 TB
Recording Flow ~= 1500 record/seconds

Mine is bigger than yours :whistle:

Nico

 
Posted : 21/02/2017 9:57 am