all users is the way to go. It bypasses the group and collection membership checks and all the rbac stuff. There is an article out there about it somewhere.
no idea what the issue is, but I would leave it at all users. On Thu, Sep 8, 2016 at 11:40 AM, Jason Wallace <[email protected]> wrote: > OK > > So I did a SQL trace to pick up the timing out sproc then traced the SPID > to find the SQL > > In this estate they have a large number of apps targeting all users and I > think that what is happening is that the SP is trying to process too much > data in the time frame > > Sent from my iPhone > > > On 8 Sep 2016, at 17:27, Mike.Davis <[email protected]> wrote: > > > > 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. > > > > > > > > > > > > >
