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
