Openlab CDS 2.4 is running very slow.

Hi,

Our Openlab CDS 2.4 is running very slow at the moment, data upload to Content Management takes hours. Could someone advise on why is the system this slow suddenly?

Thanks in advance.

Parents Reply Children
  • Hello,

    You should open a ticket with https://servicedesk.li.agilent.com/support if you experience the issue again. If you are using SQL as your database engine, a common issue is index fragmentation. You should be doing the maintenance actions below if using SQL. 

    Marty Adams 

    3 Rebuild indexes based on the following recommendations.

    Run an index fragmentation check, and:

    • Rebuild anything that is >30% fragmented.

    • Re-organize anything that is between 5 and 30% fragmented.

    See docs.microsoft.com/.../reorg anize-and-rebuild-indexes for more information.

    Optimizing Microsoft SQL Server to work with Content Management To ensure that your performance does not degrade, perform the following weekly maintenance operations on your SQL server.

    • Recompute statistics by running the command: EXEC sp_updatestats

    • Clear the buffers by running the command: DBCC DROPCLEANBUFFERS

    • Clear the cache by running the command: DBCC FREEPROCCACHE

Was this helpful?