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

  • Question

  • Hi i have a problem with my SCSM 2016

    I have 5 servers (VMs)

    1 service manager primary MS

    2- Service manager database

    3-Service manager DW MS

    4 - DW database

    5- Secondary MS and Self Service Portal

    all server have enough ram and CPU but my primary management servers event viewer shows like this

    and event viewer full of this warning events

    when i try to create template or something like that i takes too long 

    Friday, October 20, 2017 1:55 PM

All replies

  • Hello,

    Please try to enable Named Pipes under Protocols for MSSQLSERVER:

    1. Open SQL Serve Configuration Manager;

    2. Click SQL Server Network Configuration;

    In addition, please also refer to article below to troubleshoot this issue:



    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, October 23, 2017 2:22 AM
  • Hi,

    how many connectors do you have?$

    Do they all sync fine?

    Do you have many custom workflows?

    Does your SQL instance have enough memory? (Not the VM, but the instance itself)

    Can you please filter out this event an check what other events are logged on the primary MS?

    Many thanks in advance.


    Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!) Blog: https://blog.pohn.ch/ Twitter: @StoyanChalakov

    Monday, October 23, 2017 9:22 AM
  • I didnt have any custom workflows

    i have these connectors

    sql server had 32 GB RAM , instance had 30 GB RAM  8 Virtual CPU

    i filtered event viewr and all warning error were  these errors

    Monday, October 23, 2017 8:16 PM
  • And I also enabled nemaed pipes and, set paralelism from 0 to 2 , it didnt work , im using sql server 2016 
    Tuesday, October 24, 2017 4:21 AM