Here’s some information on a new Configuration Manager hotfix we released to address a problem in the following scenario:
- You’re running Microsoft System Center Configuration Manager version 1511.
- You create a large number of packages (for example, several hundred) and distribute them to lots of pull distribution points (for example, thousands of them).
Distribution Manager (DistMgr) processes the .pul files from the pull distribution points (DPs) by running the following query, and in this scenario it can take 3–4 seconds to run this query when there are many rows in the PkgStatus table:
select s.ID, s.PkgServer, s.SiteCode, p.StoredPkgVersion, s.Status, r.PkgVersion, r.ActionState, r.ActionData, p.PkgFlags, p.ShareType
from PullDPResponse r
join PkgStatus s on r.PkgStatusID = s.PKID AND r.PkgStatusID = PUL_ID
join SMSPackages p on s.ID = p.PkgID
This occurs because the PkgStatus view uses an ISNULL statement, and this causes SQL to perform an Index Scan instead of an Index Seek.
A new hotfix is available that cuts this time to about 28 milliseconds. For complete details and a download link, please see the following:
3101706 – FIX: DistMgr is slow to process .pul files from pull DPs in System Center Configuration Manager version 1511 (https://support.microsoft.com/en-us/kb/3101706)