Citrix Virtual Apps and Desktops - Increased SQL Server Resource Utilization

book

Article ID: CTX696681

calendar_today

Updated On:

Description

Customers running Citrix Virtual Apps and Desktops (CVAD) 2503 or later may observe elevated CPU and resource utilization on the SQL Server hosting the Monitoring database.

The issue is most noticeable in environments where the "Enhance Director with Citrix uberAgent data" Citrix policy is enabled and applied broadly to all delivery groups or machines in the site.

Cause

When the "Enhance Director with uberAgent data" policy is scoped to all delivery groups or machines, the volume of performance data collected and written to the Monitoring database increases significantly. This high write throughput can put considerable pressure on the SQL Server, particularly on tables such as ActiveApplicationLaunch and ApplicationUsageSummary. Over time, this can accelerate the fragmentation of columnstore indexes on those tables, leading to degraded query performance and sustained high CPU utilization on the SQL Server.

Resolution

To reduce SQL Server load, restrict the "Enhance Director with uberAgent data" policy to only the delivery groups or machines where uberAgent data is actively needed, rather than applying it site-wide.

Steps to restrict the policy scope:

Open Citrix Studio (or Web Studio).
Navigate to Policies.
Locate the "Enhance Director with Citrix uberAgent data" policy.
In the policy and under Assign Policy To, add delivery group or machine filters to target only the required subset of delivery groups or machines.
Save and apply the policy.