Citrix Director 7.X: Average Logon Duration Not Displayed In Graph On Director Dashboard As Well As Logon Performance graphs under Trends
Article ID: CTX262023
Updated On:
Description
Average Logon Duration did not display in Graph on Director dashboard as well as Logon Performance graphs under Trends. However, the logon duration data was available in the tables as shown below.
- We looked at the CDF traces from DDC and found that the logon duration for Trends was being fetched from MonitorData.SessionActivitySummary table.
- Upon checking the Monitor Database tables it was found that the logon duration data is present in Monitordata.Sessions table not in Monitordata.SessionActivitySummary table which implies that VDA’s are sending the logon duration payload to the broker but the information is not getting consolidated in Monitordata.SessionActivitySummary table.
- Graphs displayed on Citrix Director fetch information from Summary Tables and since the information was missing in Monitordata.SessionActivitySummary, the Logon Duration graphs were blank both on the Director Dashboard as well as under Trends.
- On exporting the MonitorData.TaskLog table it was found that there were “Execution Timeout Expired” Error messages getting logged for various consolidation tasks (Task 1) as shown below.
Environment
Citrix is not responsible for and does not endorse or accept any responsibility for the contents or your use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever Web site you use is free of viruses or other harmful items.
Resolution
Running the below Database Maintenance tasks to Rebuild and reorganize the indexes and Update statistics in order to improve SQL query performance.
1. Update stats by using below SQL query
Exec sp_updatestats
2. Create index maintenance plan as below
• Reorganize indexes – Every Midnight
• Rebuild Indexes -Every Weekend
Problem Cause
Monitor Database consolidation task was timing out due to poor SQL query performance.
Issue/Introduction
Citrix Director 7.X: Average Logon Duration Not Displayed In Graph On Director Dashboard As Well As Logon Performance graphs under Trends
Additional Information
Note: Database Consolidation tasks are responsible for adding entries in Summary Tables. Also, all the results for Grooming, Consolidation Reaping Stored procedures/tasks are recorded in MonitorData.Tasklog Table.
Always take a SQL DB backup before making any changes to the SQL database.
Please refer to “Index Maintenance” section in article https://docs.citrix.com/en-us/advanced-concepts/implementation-guides/database-sizing-guidance-for-xendesktop-7-6.html
Re-organize and Rebuild Indexes
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-2017
Update statistics
https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-2017
