Director: Dashboard not showing correct session count data

Director: Dashboard not showing correct session count data

book

Article ID: CTX616585

calendar_today

Updated On:

Description

Director dashboard showing wrong data
Session count in Studio and Director Dashboard is incorrect

Resolution

Data from dashboard comes from the below tables of Monitoring DB

 [MonitorData].[Session] 
[MonitorData].[SessionActivitySummary]
[MonitorData].[Connection]

Expand the respective tables and go to Indexes>Right Click on Indexes and Rebuild all. 
Generate a script and run it.

Problem Cause

Data Defragmented in below tables

 [MonitorData].[Session] 
[MonitorData].[SessionActivitySummary]
[MonitorData].[Connection]
 
Powered by Wolken Software