Home General Discussion

SCSM Slow / SQL Slow

CaterhamITSupportCaterhamITSupport Member Advanced IT Monkey ✭✭✭

Dear All,

I am having some issues with SCSM running very slow and every 30 seconds error below. We have change the server from SAS disks to SSD to see if it would help.

The database subscription query is longer than expected. Check the database or simplify the database subscription criteria.

 The following errors were encountered:

 Exception message: Subscription query is taking long.

Any advice would be great.

Kind Regards

Daniel

Best Answer

  • CaterhamITSupportCaterhamITSupport Member Advanced IT Monkey ✭✭✭
    edited April 2023 Answer ✓

    Managed to fix this by disabling null values in all SCSM AD Connectors and then rebooted the server.

Answers

  • CaterhamITSupportCaterhamITSupport Member Advanced IT Monkey ✭✭✭
    edited April 2023 Answer ✓

    Managed to fix this by disabling null values in all SCSM AD Connectors and then rebooted the server.

Sign In or Register to comment.