Difference between revisions of "Performance Tweaks"

From TMS Support Wiki
Jump to navigation Jump to search
(Created page with "Like all software, PTS 5 is not immune to occasional temporary performance issues. =Symptoms= Various functions of the PTS application take a long time to load or to process. =Common causes= <ol> <li>The database has grown large and the data has become fragmented.</li> <li>Printer settings are not optimal.</li> <li>Other software on a shared server is hogging resources.</li> <li>An unoptimised or expensive third party query is hitting the PTS database.</li> <li>The serve...")
 
Line 1: Line 1:
Like all software, PTS 5 is not immune to occasional temporary performance issues.
Like all software, PTS 5 is not immune to occasional temporary performance issues.
=Symptoms=
=Symptoms=
Various functions of the PTS application take a long time to load or to process.
Various functions of the PTS application take an unsatisfactory amount of time to load or to process.
 
=Common causes=
=Common causes=
<ol>
<ol>

Revision as of 13:12, 19 July 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.

Solutions

  1. Index the PTS database.
  2. Turn off bi-directional support.
  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.
  5. Consider upgrading your server hardware to the recommended PTS 5 specification.