The below script will create a database [TConnectTools] and associated SQL Agent jobs with the purpose of automatically tuning the T-Connect databases. This is based on the automatic SQL tuning solution provided by Ola Hallengren here: SQL Server Index and Statistics Maintenance (hallengren.com)
The [sp_RebuildIndexes] job is configurable to automatically tune statistics and indexes on the TctepDb, TConnectEDI837P and TConnectEDI837I databases. Update the sp_RebuildIndexes stored procedure prior to or immediately after executing the SQL script against the T-Connect SQL Server.
- Update The comma separated list of databases with list of database you would like to tune.
- Change other parameters to the IndexOptimize stored procedure following the following instructions SQL Server Index and Statistics Maintenance (hallengren.com).