1Y0-312 Performance and Scalability Optimization Practice Question
An administrator supports a Citrix Virtual Apps and Desktops 7 environment where the Delivery Controller database is hosted on a dedicated Microsoft SQL Server instance. During the morning logon peak, the Controller takes over 45 seconds to respond to brokering requests, and the SQL Server shows sustained 90% CPU with heavy read activity against the monitoring data tables. The administrator must reduce the database load without redesigning the site. Which action should the administrator take?
⚠ Common exam trap
The trap here is assuming that tuning SQL Server engine parameters such as MAXDOP will fix brokering latency, when the real issue is co-locating two very different database workloads on one instance.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Move the monitoring database to a separate SQL Server instance and point the Monitoring Database connection string to that instance.
Monitoring data generates the majority of SQL activity in a busy Citrix site because every session, logon, and application event is recorded. Placing the monitoring database on its own SQL Server instance separates that write-heavy workload from the configuration database that brokers sessions, so brokering queries stop competing for the same CPU and I/O. This is a supported, minimally disruptive change that directly addresses the observed symptom.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Move the monitoring database to a separate SQL Server instance and point the Monitoring Database connection string to that instance.
Why this is correct
The monitoring database is written heavily by every VDA and broker event, so separating it from the site configuration database removes that write/read contention from brokering queries. In Citrix Virtual Apps and Desktops 7, the monitoring database can be hosted on its own SQL Server instance and configured independently, which directly lowers the load on the instance servicing brokering requests during peak logon.
- ✗
Enable the Citrix Director data collection caching option on each VDA to reduce the number of monitoring records sent to SQL.
Why it's wrong here
There is no supported Director setting that caches monitoring data on the VDA to reduce SQL writes; the VDA monitoring service streams events to the monitoring database continuously. Disabling or altering monitoring collection would reduce visibility rather than relieve the specific contention between monitoring tables and the site configuration database on the same SQL instance.
- ✗
Configure the Delivery Controller to use SQL Server Express LocalDB for the monitoring database.
Why it's wrong here
SQL Server Express LocalDB is not a supported database for a production Citrix Virtual Apps and Desktops 7 site, and its 10 GB database size limit would be exceeded quickly by monitoring data. LocalDB also cannot be shared across multiple Controllers, so it would break the site rather than reduce the load on the existing SQL Server instance hosting the site database.
- ✗
Increase the SQL Server maximum degree of parallelism to 8 so that brokering queries are processed in parallel.
Why it's wrong here
Raising MAXDOP on the SQL instance that hosts the site database does not isolate monitoring traffic and can actually increase CPU pressure and cause plan regressions and blocking for short brokering queries. The bottleneck described is contention between monitoring writes and configuration reads, not insufficient query parallelism, so this change would not resolve the 45-second brokering delay.
About these practice questions
This 1Y0-312 question is part of Courseiva's 186-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Citrix exam blueprint
This 1Y0-312 practice question is part of Courseiva's free Citrix certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the 1Y0-312 exam.