It was definitely supersedence in our case - we had configured each new Flash version to supersede the previous versions and it was getting overloaded (AppIntentEval just contained long lists of deployment types which had been superseded). I've cleared out most of the supersedence entries and it seems to be resolved.
Mike > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Mike.Davis > Sent: 08 September 2016 17:21 > To: [email protected] > Subject: RE: [mssms] Sloooow App Catalog > > We've been having similar-sounding issues [roughly] since we upgraded to > 1602 - not resolved in 1607. Symptom is that an App Catalog install fails > while > trying to evaluate requirements. Other app install actions (Software Centre, > required deployments) are still working, but general performance is not > great (despite 32GB RAM on the site server, I think 20GB max RAM for SQL > with 11,000 devices) - not sure if the App Catalog issues are related to > overall > performance or separate. > > We've found (and since mislaid) a reference to a Microsoft-recommended > limit to the use of supersedence and we're wondering if this processing is > causing the delay - no other obvious ideas at this point. > > I'll try to confirm what you've mentioned below if I can work out how :) > > Mike > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Jason Wallace > > Sent: 08 September 2016 15:06 > > To: jaswall/edarkosarwa/magzparmenter/<Unnamed>/pradeepe > > <[email protected]> > > Subject: [mssms] Sloooow App Catalog > > > > Hi folks > > > > I have encountered a slow App Catalog and am hoping that some kind folks > > would be able to help me out on this please. > > > > We are seeing timeouts and I have tracked this back to > > > > usp_GetApplicationPropertyValuesFiltered > > > > Which is taking 1:26 to run. > > > > This sproc is calling respolicycollmap which in this case has 84 million > > rows > > > > Any thoughts how I can improve this perf? > > > > Sent from my iPhone > > > > > > -- The Open University is incorporated by Royal Charter (RC 000391), an > exempt charity in England & Wales and a charity registered in Scotland (SC > 038302). The Open University is authorised and regulated by the Financial > Conduct Authority. > > > -- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority.
