FlexLink YOUTILIZE - Manual (Page 122)

Providing production efficiency
Page 122 of 125
• SI
limit_slide rail idler
Lim
1
1
Lim Lim Lim
X *
X
Y
) f(X Y SI
= = =
The next inspection point is over writing all these values with (hopefully) even more accurate values.
Database Requirements
Time to next service uses data from two tables in the database – ServiceLogs (max size
approximately 200 bytes per motor) and EquipmentMeasurements (max size approximately 150
bytes per motor per measurement). Each motor utilizes one ServiceLogs record as an accumulator,
so this tables’ size will never amount to much. Each motor power change is recorded in
EquipmentMeasurements, so for a dumb motor this will be very few records, for a smart motor
under constantly varying load this could become quite high.
At a large installation with more than 100 motors, and also full Production Montioring the database
can grow to as much as 6GB after 3 months. Such installations automatically include a full MSSQL
license, which has a maximum data size of 524 petabytes, so the only real limitation is the size of the
drive used to contain the database. The free MSSQL Express version installed with Serice Level
Monitoring has a limitation of 4GB of data, should more be required, then a full MSSQL license must
be purchased. The software contains a cleanup routine that removes all data over 6 months of age
and this does not have any effect on Time to next service which needs the ServiceLogs record and
the last EquipmentMeasurements record for each specific motor only. So for pure Service Level
Monitoring, the database size should not be a problem.