Routine Maintenance for TSS Data (Version 3.23 MTAS)

Routine Maintenance for TSS Data (Version 3.23 MTAS)

To ensure optimal performance and data integrity, it is recommended to regularly restructure the TSS data—similar to a defragmentation process. This maintenance task should be scheduled to run nightly, or at a minimum, at the end of each week.

Regular restructuring helps:

  • Improve system responsiveness

  • Reduce data fragmentation

  • Maintain overall stability of the TSS environment

This process should only be run when nobody is in TSS.

 

From the server computer down to the left of the time look for an icon first that looks like an upside-down V or the tip of an arrow.

Under the ^ look for the green IN icon then double click that icon it will open a window like

 


from there go to tools data management and do the third choice which is Restructure TSS Data 

It will ask you two questions are you sure you want to run the restructure you click yes.

Then it will ask if you want to stop the application server and you click yes to that and then it will go through and complete the process of running like the equivalent of a defragment for the TSS data. 

 

    • Related Articles

    • Import data into TSS from XLS file

      Import data into TSS from XLS file 1 Click the tools menu then data then Import Data into TSS 2 Click Next 3. Choose the type of data like Inventory 4. Navigate to where you saved your .xls file 5 Next choose the sheet and it should preview your data ...

    • Starting TSS XP Problems

      TSS XP has two components to it MTAS.exe and TSSXP.exe The MTAS.exe without it running and able to communicate through the firewall, TSSXP will not run The mtas program does lots of things two important things it does it controls updates from the ...

    • Backups in both TSS Plus and TSS XP

      TSS PLUS: Backups are easily created through the Database Maintenance Wizard when you click on the Ambulance icon in the bottom right of the TSS main menu. Select 'Manually Specify', click next and choose 'Backup Database Files', select the ...

    • TSS Plus important tools and tips

      Fixdata.exe is the tool to backup and try to help with fixing your Plus data In TSS2000 it is the program that runs when you click on the ambulance within TSS. In general have all users close TSS before running Fixdata Do the manual choice from the ...

    • Moving a TSS XP Server to a new computer

      1. Go to the server computer for TSS XP and look for the ^ icon near the time, and locate the Application server icon at the bottom right in the task bar or hidden system tray (Green dot with letters IN)and double click it. 2. Click on Tools at the ...