VERIFIED SOLUTION i

How to resolve Confirm, Connector, Workzone and ConfirmConnect are slow to respond

Product Feature: Application Infrastructure

Issue

Confirm, Connector, Workzone and ConfirmConnect are slow to respond.

Cause

The problem is affecting different apps that connect to the database so a possible cause is SQL that is running against the database.

Resolution

UPDATED: May 16, 2017
If one specific piece of SQL is taking a long time stop it running if it is a Data Source.  If it is SQL that is generated by the software check the SQL execution query plan to see if it has been updated recently and is optimised.