Do you have your antivirus exceptions in? Namely the one for log files on the primary... That can greatly slow down the console.
On Tue, May 19, 2015 at 3:57 PM, Robert Spinelli <[email protected]> wrote: > Actually had a mistake in my last SQL query, I’ve removed that. > > > > *From:* Robert Spinelli [mailto:[email protected]] > *Sent:* Tuesday, May 19, 2015 4:54 PM > *To:* mssms ([email protected]) > *Subject:* Deployments Monitoring - Slow in console > > > > Has anyone ever seen when they click on Monitoring / Deployments in SCCM > console, it 1st displays applications, and then a minute pause > (literally) and then it “refreshes” and shows remaining software updates? > > > > We added about 800 new applications to the console and we started seeing > this behavior. I’ve tracked it thru smsprov and you can see its actually > run 3 separate queries when you click on monitoring / deployments. > > > > SELECT * FROM SMS_DeploymentSummary WHERE FeatureType IN (1, 2, 3) > > SELECT * FROM SMS_DeploymentSummary WHERE FeatureType IN (5, 7) > > SELECT * FROM SMS_DeploymentSummary WHERE FeatureType IN (6, 11) > > > > If I run the queries from WMI Explorer it comes back fast. > > > > I’ve also got the same 3 queries that is being converted from WQL to SQL, > I run those 3 SQL queries and they also return back fast. > > > > select all > SMS_DeploymentSummary.AssignmentID,SMS_DeploymentSummary.CI_ID,SMS_DeploymentSummary.CollectionID,SMS_DeploymentSummary.CollectionName,SMS_DeploymentSummary.CreationTime,SMS_DeploymentSummary.DeploymentID,SMS_DeploymentSummary.DeploymentIntent,SMS_DeploymentSummary.DeploymentTime,SMS_DeploymentSummary.DesiredConfigType,SMS_DeploymentSummary.EnforcementDeadline,SMS_DeploymentSummary.FeatureType,SMS_DeploymentSummary.ModelName,SMS_DeploymentSummary.ModificationTime,SMS_DeploymentSummary.NumberErrors,SMS_DeploymentSummary.NumberInProgress,SMS_DeploymentSummary.NumberOther,SMS_DeploymentSummary.NumberSuccess,SMS_DeploymentSummary.NumberTargeted,SMS_DeploymentSummary.NumberUnknown,SMS_DeploymentSummary.ObjectTypeID,SMS_DeploymentSummary.PackageID,SMS_DeploymentSummary.PolicyModelID,SMS_DeploymentSummary.ProgramName,SMS_DeploymentSummary.SoftwareName,SMS_DeploymentSummary.SummarizationTime,SMS_DeploymentSummary.SummaryType > from fn_DeploymentSummary(1033) AS SMS_DeploymentSummary where > SMS_DeploymentSummary.FeatureType in (1,2,3) > > > > select all > SMS_DeploymentSummary.AssignmentID,SMS_DeploymentSummary.CI_ID,SMS_DeploymentSummary.CollectionID,SMS_DeploymentSummary.CollectionName,SMS_DeploymentSummary.CreationTime,SMS_DeploymentSummary.DeploymentID,SMS_DeploymentSummary.DeploymentIntent,SMS_DeploymentSummary.DeploymentTime,SMS_DeploymentSummary.DesiredConfigType,SMS_DeploymentSummary.EnforcementDeadline,SMS_DeploymentSummary.FeatureType,SMS_DeploymentSummary.ModelName,SMS_DeploymentSummary.ModificationTime,SMS_DeploymentSummary.NumberErrors,SMS_DeploymentSummary.NumberInProgress,SMS_DeploymentSummary.NumberOther,SMS_DeploymentSummary.NumberSuccess,SMS_DeploymentSummary.NumberTargeted,SMS_DeploymentSummary.NumberUnknown,SMS_DeploymentSummary.ObjectTypeID,SMS_DeploymentSummary.PackageID,SMS_DeploymentSummary.PolicyModelID,SMS_DeploymentSummary.ProgramName,SMS_DeploymentSummary.SoftwareName,SMS_DeploymentSummary.SummarizationTime,SMS_DeploymentSummary.SummaryType > from fn_DeploymentSummary(1033) AS SMS_DeploymentSummary where > SMS_DeploymentSummary.FeatureType in (5,7) > > > > select all > SMS_DeploymentSummary.AssignmentID,SMS_DeploymentSummary.CI_ID,SMS_DeploymentSummary.CollectionID,SMS_DeploymentSummary.CollectionName,SMS_DeploymentSummary.CreationTime,SMS_DeploymentSummary.DeploymentID,SMS_DeploymentSummary.DeploymentIntent,SMS_DeploymentSummary.DeploymentTime,SMS_DeploymentSummary.DesiredConfigType,SMS_DeploymentSummary.EnforcementDeadline,SMS_DeploymentSummary.FeatureType,SMS_DeploymentSummary.ModelName,SMS_DeploymentSummary.ModificationTime,SMS_DeploymentSummary.NumberErrors,SMS_DeploymentSummary.NumberInProgress,SMS_DeploymentSummary.NumberOther,SMS_DeploymentSummary.NumberSuccess,SMS_DeploymentSummary.NumberTargeted,SMS_DeploymentSummary.NumberUnknown,SMS_DeploymentSummary.ObjectTypeID,SMS_DeploymentSummary.PackageID,SMS_DeploymentSummary.PolicyModelID,SMS_DeploymentSummary.ProgramName,SMS_DeploymentSummary.SoftwareName,SMS_DeploymentSummary.SummarizationTime,SMS_DeploymentSummary.SummaryType > from fn_DeploymentSummary(1033) AS SMS_DeploymentSummary where > SMS_DeploymentSummary.FeatureType in (6,11) > > > > I’m not sure where/how else to figure this out, its totally bizarre. > > > > Thanks > > > > Rob > >
