Solution Maintenance
Following are some of the guidelines for maintenance of Application Database:
 |
• Do not perform any upgrades before contacting PTC to confirm that compatibility has been successfully tested.
• Ensure that the database administrator adds the ThingWorx Platform and ThingWorx Application databases to the maintenance plan.
|
• Configure a full back-up daily.
• Index fragmentation & Index Rebuild (The database administrator can analyze to determine frequency).
• SQL report to check for fragmentation, deadlock, size, and so on.
• Optimize the SQL server configuration following best practices (Example: database on a separate drive, TempDB, Logfiles, MaxMemory, FillFactor, MaxDop).
• Any other applicable best practices as determined by the database administrator.