If you are really just concerned with the Sync time then go into the Server configuration and set the Archive for the Event Journal and Historic Data to 1 week or a longer time frame that you are sure you won't want to edit the events or history. It won't have to sync anything that is older than the Archive setting, because that data is set to not be changeable so it can be archived if you want to archive it. Personally I don't archive anything, it is a pain in the butt because it is made to archive to removable media. Where history preservation is important my customers rely on system backups. Size is controlled by how much is written to the Events or History. On your points with history enabled, from the Historic tab, you can apply compression to limit how much is being written. Points and other database objects that have events configured will record an event every time that condition is true. If you think some of these events that are configured are unnecessary set them to None and this will reduce the quantity. Yes, you can check for the History setting from SQL, but I don't remember what you need to do to get it. I would just use the Bulk Edit tool. Check the entire database then select each point type and then check the historic enabled. Export it to an excel file.
... View more
