GN4 is slow

Build 1501 on 14/Nov/2017  This topic last edited on: 17/Mar/2016, at 18:01

GN4 may become slow in the following known situations:

•The connection to the GN4 server is extremely slow. Check the connection speed and if it looks normal, consider to perform IISreset on the GN4.

•The GN4 IIS server or SQL server are extremely busy.

•The publishing destinations are overfull. See Purging publishing destinations.

•The AuditSearch, AuditLoad and AuditCheckOut permissions are enabled and this causes very high SQL traffic.

•The VMs are wrongly configured (with the wrong number of virtual sockets - see the "VM configuration for best performances" paragraph in the Hints for a Faster System topic)

To help us to help you

1.Capture a video of what you consider slow performances and then let us have it.

2.Install and run Fiddler, and then capture the trace during what's considered a slow operation and let us have it.

GN4 on client computers may become slow when...

DESCRIPTION OF PROBLEM

SOLUTION

Slow operations

Check the CPU and memory usage on the IIS server and on the SQL server (if on separate machine). Neither one should be above the expected values. If the memory usage on the SQL server is high, check if there are traces left active - in such a case, a trace can take almost all memory. Stop the trace if so. Consider to restart the server, as soon as possible.

Opening a page in Fred4 takes more than 30 second - in a LAN connection.
(fixed in build 1172)

The drop-downs used to select colors in the Fred4 palettes are refreshed every time you open or select a page – even if the palettes are not visible.  To fill the list of colors Fred4 converts each color in the color table from CMYK to RGB – each one of these conversions resulted in a failed call to create the color transformation, and on a huge color table (2000+ colors ) it was taking forever. With a smaller color table you don’t notice the problem.

Since build 1172 the color editing dialog lists only the color profiles that can actually be used to do a CMYK to RGB conversion – or that at least don’t give any error (there are still some strange ones that return always black for example, but they won’t slow down things).

Slow opening of pages

(fixed by recycling IIS)

IIS event log contained, every minute, an exception such as:

    Exception type: LockTimeoutException 

    Exception message: Exception of type 'TeraDP.GN4.Common.LockTimeoutException' 

    was thrown.

      at TeraDP.GN4.Common.TimedLock.Lock(Object o, TimeSpan timeout)

      at TeraDP.GN4.EditorialServer.EditorialServer.GetPagePreview(Int32 pageId, 

      String optionsName, Boolean force, String& etag)

Slow opening of pages or articles, due to a huge number of repeated tags

Check if the page contains articles that have a huge number of repeated tags, e.g. a series of tags such as >is<>bd 1<>is<>bd 1<>is<>bd 1<>is<>bd 1<>is<>bd 1<>is<>bd 1< or similar. The problem start to happen if the number of concatenated tags exceeds several thousands. Edit text and delete extra tags to resolve.

General slowness of the system

Make sure that AuditSearch, AuditLoad and AuditCheckOut permissions are not enabled, as they cause high SQL traffic.

Slow saving of editions

(fixed in 1.6.1844 or newer)

Upgrade to 1.6.1844 or newer.