Managing MSSQL Database Size

As the MSSQL database size grows, more resources on both the FactoryTalk AssetCentre client and server computers are used. As of version 6.10, FactoryTalk AssetCentre can be configured to automatically monitor the size of the database and its various components, including total size, diagnostic log sizes, and archive version totals. It is strongly recommended to use this feature in conjunction with the manual cleanup tools such as Archive Cleanup and Log Cleanup wizards (see sections on these later in this document.) Refer to Knowledgebase Document ID: QA38697 - FactoryTalk AssetCentre Database Management and Knowledgebase Document ID: QA52221 – FactoryTalk AssetCentre Database Management FAQs for more information.

It is also recommended to monitor the size of the transaction logs. Particularly in systems that have constantly changing data like FactoryTalk AssetCentre, these logs tend to grow very quickly. Where possible, set the database's recovery mode to simple and perform Full backups as part of the system backup plan, which will allow for the scheduled shrinking of these logs. Other scheduled operations should include indexing and free space cleanup operations. The exact implementation of these policies should be determined by the end user’s database management team.