locked
SCSM log full of warnings - The database subscription query is longer than expected RRS feed

  • Question

  • Hi!

    My SCSM setup (~250 users) has become super slow. Each action hangs for 1 -5 minutes.

    Event viewer shows lots of errors; SMCMDB Subscription Data Source Module -  The database subscription query is longer than expected

    Listing each and every internal workflow :
    Subscription name: ServiceManager.ReleaseManagement.ActivityStatusChangedRule
    Subscription name: ServiceManager.ActivityManagement.ActivityAddedRule
    Subscription name: ServiceManager.ActivityManagement.ReviewActivityActiveRule

    etc., etc. etc.


    Egils Zonde from Technet

    Monday, September 23, 2013 10:08 AM