SCCM - IPS enabled network

karthik palani 1,016 Reputation points
2022-11-30T07:29:38.03+00:00

HI All,

We are facing some issues while running the report in SCCM. We have latest SCCM CB version, when we run any report from console or directly in the SQL reporting server. It takes 25 to 30 mins to process, we found Intrusion prevention service policy is causing this issue.

When we disable it, it reduce the generating time to 5 to 10 mins. Does anyone faced this issue, what needs to be allowed in IPS to process quicker report

Appreciate your response

Windows Server Infrastructure
Windows Server Infrastructure
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Infrastructure: A Microsoft solution area focused on providing organizations with a cloud solution that supports their real-world needs and meets evolving regulatory requirements.
530 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    2022-11-30T11:18:50.757+00:00

    this is a question for your ips software. they can tell you what the ips sw is doing and set up exclusions.
    don't forget you av sw too.
    https://www.recastsoftware.com/resources/configuration-manager-2012-and-anti-virus-software-exclusions-for-site-servers/

    1 person found this answer helpful.
    0 comments No comments

  2. Garth 5,801 Reputation points
    2022-11-30T12:10:27.96+00:00

    btw i should also add that 5-10 minutes for most enviroments is a long time. i would check your Sql health to see if there is anything that can be done such as enabling ola's script. https://www.recastsoftware.com/resources/installation-guide-to-ola-hallengrens-sql-server-maintenance-solution/

    0 comments No comments

  3. Limitless Technology 44,096 Reputation points
    2022-12-02T12:49:27.293+00:00

    Hello there,

    You need to maintain your SQL DB regularly, like rebuilding indexes, etc. There is a good chance the reason for this is a defragmented underlying SQL Server database. Therefore you should rebuild the indexes which can be done in various ways and with different tools.

    SQL Server Reporting Services uses the Reporting services point account to retrieve the data for Configuration Manager reports from the site database. Make sure all the necessary services are running and not being tackled by malware services.

    The below thread discusses the same issue and you can try out some troubleshooting steps from this and see if that helps you to sort the Issue. https://social.technet.microsoft.com/Forums/en-US/c12eb3b3-4292-48ab-a52c-59e605686753/sccm-report-takes-forever-to-load?forum=configmanagergeneral

    -------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept it as an answer–

    0 comments No comments

  4. karthik palani 1,016 Reputation points
    2022-12-04T09:04:43.33+00:00

    Thanks all,

    Weird, we saw network traffic to internet from SQL server to Internet via 443. Not sure why it is trying to communicate outside the domain

    After enabling the internet the reports are fast and normal now. Any insights on this please

    Any specific URL i need to open for SQL services

    0 comments No comments