Difference between revisions of "Performance Tweaks"

From TMS Support Wiki
Jump to navigation Jump to search
Line 16: Line 16:
<ol>
<ol>
<li>[[Database_Indexing|Index the PTS database]].</li>
<li>[[Database_Indexing|Index the PTS database]].</li>
<li>Turn off [[Label_Printer_Installation|bi-directional support]]. <i>(Please do not underestimate the performance impact of this setting even if you have never heard of it before)</i></li>
<li>Turn off [[Label_Printer_Installation|bi-directional support]].<br/>
<i>(Please do not underestimate the performance impact of this setting even if you have never heard of it before)</i></li>
<li>Use a resource monitor or the SQL performance dashboard to identify the application at fault and then contact the manufacturer.</li>
<li>Use a resource monitor or the SQL performance dashboard to identify the application at fault and then contact the manufacturer.</li>
<li>Use SQL performance dashboard to identify the expensive query and have IT or the manufacturer optimise it and/or reduce its frequency. <i>(This issue seems to be becoming more common, please test your queries for performance at scale before rollout)</i></li>
<li>Use SQL performance dashboard to identify the expensive query and have IT or the manufacturer optimise it and/or reduce its frequency.<br/>
<i>(This issue seems to be becoming more common, please test your queries for performance at scale before rollout)</i></li>
<li>Consider upgrading your server hardware to the [[High_Level_Design_Document|recommended PTS 5 specification]].</li>
<li>Consider upgrading your server hardware to the [[High_Level_Design_Document|recommended PTS 5 specification]].</li>
<li>In Setup > Application Settings, locate the "skip checking if PTS is online" setting (OFFLINE) and set to Yes.</li>
<li>In Setup > Application Settings, locate the "skip checking if PTS is online" setting (OFFLINE) and set to Yes. This tells PTS not to attempt any remote connections.</li>
</ol>
</ol>

Revision as of 09:26, 3 October 2022

Like all software, PTS 5 is not immune to occasional temporary performance issues.

Symptoms

Various functions of the PTS application take an unsatisfactory amount of time to load or to process.

Common causes

  1. The database has grown large and the data has become fragmented.
  2. Printer settings are not optimal.
  3. Other software on a shared server is hogging resources.
  4. An unoptimised or expensive third party query is hitting the PTS database.
  5. The server/s only meet the bare minimum hardware requirements.
  6. PTS is trying to reach tmsinsight.com for support contract and software licensing notifications, but your PTS server has no access to the internet.

Solutions

  1. Index the PTS database.
  2. Turn off bi-directional support.
    (Please do not underestimate the performance impact of this setting even if you have never heard of it before)
  3. Use a resource monitor or the SQL performance dashboard to identify the application at fault and then contact the manufacturer.
  4. Use SQL performance dashboard to identify the expensive query and have IT or the manufacturer optimise it and/or reduce its frequency.
    (This issue seems to be becoming more common, please test your queries for performance at scale before rollout)
  5. Consider upgrading your server hardware to the recommended PTS 5 specification.
  6. In Setup > Application Settings, locate the "skip checking if PTS is online" setting (OFFLINE) and set to Yes. This tells PTS not to attempt any remote connections.