Trending in Support: Track-It! 11.x Performance tuning!

Version 2
    Share This:

    In support we receive several calls regarding the slow performance of Track-It! 11.4 and above. There could be several reasons behind the slowness of Track-It!.If you see slowness when opening a work order or adding Notes to a Open work order, then check the following KB Article.

     

    Work Orders containing a lot of Notes, extensive Notes, or large amounts of code and external links in Notes are slow to open or add Notes to

     

    Next below are a list of steps that you can take to improve Track-It! performance.

     

    1. Upgrade to latest version. (Many issues are resolved and performance can be improved by upgrading to the latest version)

    2. Install the latest windows patches on the Application and WebServer. Upgrade to the latest version of SQL or apply the SQL Server patches if you are using a Full Version of SQL Server.

    3. Try performing each of the steps given below:

     

    Purge the following logs via the Technician Client:

     

    Configuration --> Administration --> E-mail configuration --> Automated Schedule

     

    Configuration --> Administration --> Directory Importer --> Automated Schedule

     

    Configuration --> Administration --> System Health Monitor

     

    Configuration --> Reports --> Scheduled Reports --> Automated Schedule

     

    Configuration --> Help Desk --> Scheduled Work Orders --> Automated Schedule

     

    Configuration --> Change Management --> Automated Schedule

     

    Configuration --> Inventory --> Asset Monitor --> Activity Log

     

    Configuration --> Help Desk --> Work Order Events --> Automated Schedule

     

    4. If you are unable to purge a log due to SQL timeout or other, you will need to execute a SQL query on your Track-It! database (TRACKIT_DB by default).

     

    Execute the following to check usage on the systemlog table:

     

    --To find out the number of records in a table:

     

    select count(*) from systemlog;

    select count(*) from audit_que;

    select count(*) from workstation_file_captures;

    Select count(*) from NotificationAttachment;

    Select count(*) from notificationqueue;

     

     

    --To truncate the data from a table, run the following Queries;

     

    TRUNCATE TABLE SystemLog;

    Truncate table audit_que;

    truncate table workstation_file_captures;

    Truncate table NotificationAttachment

     

    5. Optional, but consider rebuilding your Track-It! search database index by grabbing the latest TIReindex batch script from Batch file to rebuild indexes and SearchData contents in Track-It! and executing it on your Track-it! server

     

    6. Perform due diligence on the mailbox of the e-mail address your Track-It! is configured to send e-mail notifications from. Log into that mailbox, empty the Inbox Items,Deleted Items folder, and see if any other cleanup is necessary.

     

    7. Reduce the number of Open work orders to less than 300. Your Email Monitor scans all these Open Work orders for Events that trigger the email Notifications. The larger the number of Open work orders, the more time it will take to process these triggering events.

     

    8. Rebuild Database Indexes:Database index fragmentation can cause Track-It! performance to suffer. Keeping fragmentation to a minimum will help to ensure the database is running as efficiently as possible

     

    Track-It! System Health - Database Index Fragmentation

     

    9. Turn-off Work order Preview from the Helpdesk Module.

    10. Finally check out all the steps that are provided in the support Article TIA03326.

     

    Give this instructions a try and feel free to share your comments if you see improvements in the performance.