After upgrading Citrix Storefront to 2203 Cu4, a high number of launch failures or enumeration may be reported by end users.
Upon checking, you may notice that there is a high load on the CTX_Site database which is related to stored procedures being invoked.
As a result of this, it causes session launch and enumeration issues as the high load of requests are impacting users launching and enumerating their resources.
The issue is caused by increased NFuse requests(between StoreFront and DDC) for application enumeration data, which overwhelms DDC request processing capacity.