We we had a weird one. We are running SQL 2014 and installed in native. We changed DB compatibility to 110 and the errant sproc started to behave
Sent from my iPhone > On 12 Sep 2016, at 16:51, Mike.Davis <[email protected]> wrote: > > 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. > > > >
