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.
