I know the hub stores the incoming alarm and QOS messages in *.sds files.
Is there a size limit to these files I need to worry about should my back end SQL server go down and I need to retain the data on my Primary HUB?
Hub 5.80 and lowered used a single <QueueName>.sds file.
Where there was no codded limit to this file size support did noticed once these got above 2 gigs in size they became unstable.
If they got much over 10 gigs there was usually problems encountered trying to get this inserted into the database.
As of the 7.x series hub the files are now stored in directories with mutiple smaller hub.sds files.
Again there is not upper limit coded in the product. The limit here really becomes one of drive space on the Primary UIM hub.
As for inserting the data...that will be handled by the data_engine and will depend on the throughput and what the SQL Server will allow as far as data to pass.
A big factor here is Memory and read/write speed