416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Tracking Dashboard Performance

Hide navigation
RSS
Modified on Tue, 02 Sep 2014 11:44 AM Categorized as Administration, Level-Advanced
Click to return to: Documentation | Installing and Administering Dundas Dashboard


Overview

In Dundas Dashboard 5.0.2 or later, administrators can enable the tracking of dashboard performance via the configuration file. Statistics similar to the data presented in the Performance Information dialog is recorded in both XML and text format. This data is written to the Dundas Dashboard Application DataStore database automatically whenever a user views a dashboard.

Note: Performance tracking is applicable to Silverlight viewing only (⪚ using Viewer.aspx or the Enhanced Viewer).

Enabling performance tracking

To enable performance tracking, you must uncomment and set the DashboardPerformanceTrackingEnabled key to True in the Dundas Dashboard Configuration File.



After making changes to the configuration file, you must restart the Dundas Dashboard website for the changes to take effect.

Sample dashboard

Download this sample dashboard and import it to your instance using the project manager. This sample tracks the performance of the dashboard instance and displays key metrics for all the dashboards in that instance: Sample: Tracking Dashboard Performance

DataStore database

DashboardPerformance table

When performance tracking is enabled, statistics are recorded to a table in the Dundas Dashboard Application DataStore database. For example, if your Dundas Dashboard instance is named Instance1, the corresponding SQL Server database would be Dundas Dashboard Instance1 DataStore.

The performance data is stored in the dbo.DashboardPerformance table, which has the following columns:

ColumnDescription
IdA unique ID identifying this tracking event.
SessionIdThe ID of the user's login session. Can be used to differentiate between users who are using the same login account (⪚ embedded viewer scenarios).
AccountIdThe ID of the user (account) viewing this dashboard.
AccountNameThe username of the user (account) viewing this dashboard.
DashboardIdThe ID of the dashboard (or embedded dashblock) being viewed.
EntryDateThe UTC date and time the viewing began.
TotalLoadTimeHow long it took to load the dashboard (in milliseconds).
PerformanceDataThe performance data in XML format.
ReportThe performance data in a text format (similar to results displayed in the Performance Information dialog).

The DashboardPerformance table in the Dundas Dashboard DataStore database (SQL Server Management Studio).

The DashboardPerformance table in the Dundas Dashboard DataStore database (SQL Server Management Studio).


Tip: You can join the above table with the FileSystemObject table to get the name of the dashboard, for example.

Examples

Report

Here is an example report:

Performance Information for Dashboard "Executive"
--------------------------------------------------------------------------------
Number of controls: 31
Number of KPIs and datasets: 13
Total Number of data points: 128
Total time to view dashboard ------------------------------- 5.16 seconds.

By Location - Total server time --------------------------------------- 0.44 seconds. - Total transport ----------------------------------------- 0.15 seconds. - Total client time --------------------------------------- 4.56 seconds.

By Task - Dashboard Definition ------------------------------------ 2.22 seconds. - Data Object Definitions --------------------------------- 0.22 seconds. - Dashboard Data Retrieval -------------------------------- 0.58 seconds. - Render data controls ------------------------------------ 2.11 seconds.

Task Details ---------------------------------------------------------------

Dashboard Definition: 2.22 seconds. - Deserialize dashboard definition --------------------- 1401 milliseconds. - Processing on client ---------------------------------- 821 milliseconds.

Data Object Definitions: 0.22 seconds. - Processing on server ----------------------------------- 53 milliseconds. - Transport ---------------------------------------------- 90 milliseconds. - Processing on client ----------------------------------- 73 milliseconds.

Dashboard Data Retrieval: 0.58 seconds (Server time: 0.39 seconds) - 7 of 13 results skipped as duplicates. - Building data queries --------------------------------- 171 milliseconds. - Running database queries ------------------------------ 124 milliseconds. - Server data processing --------------------------------- 16 milliseconds. - Client data processing --------------------------------- 81 milliseconds. - General server processing ------------------------------ 60 milliseconds. - Transport ---------------------------------------------- 61 milliseconds.

Individual Data Query Details ---------------------------------------------- Measurements under 9 milliseconds are aggregated together.

- Expense, year over year by month: 7 data points. - Running database query -------------------------------- 28 milliseconds. - Aggregate for subtreshold timings ---------------------- 1 milliseconds.

- Expense, year over year by month: 7 data points. (*) Duplicate item. Query skipped.

- Margin, year over year by month: 7 data points. - Building data query ----------------------------------- 49 milliseconds. - Running database query -------------------------------- 33 milliseconds. - Server data processing -------------------------------- 15 milliseconds. - Aggregate for subtreshold timings ---------------------- 5 milliseconds.

- Margin, year over year by month: 7 data points. (*) Duplicate item. Query skipped.

- Revenue, year over year by month: 7 data points. - Running database query -------------------------------- 33 milliseconds. - Aggregate for subtreshold timings ---------------------- 2 milliseconds.

- Revenue, year over year by month: 7 data points. (*) Duplicate item. Query skipped.

- Sales by Region: 80 data points. - Running database query -------------------------------- 21 milliseconds.

- Support Expense, by month: 1 data points. - Building data query ---------------------------------- 118 milliseconds. - Client data processing -------------------------------- 76 milliseconds. - Aggregate for subtreshold timings --------------------- 14 milliseconds.

- Support Expense, by month: 1 data points. (*) Duplicate item. Query skipped.

- Support Expense, by month: 1 data points. (*) Duplicate item. Query skipped.

- Variable Operational Expenses, by month: 1 data points. - Aggregate for subtreshold timings ---------------------- 2 milliseconds.

- Variable Operational Expenses, by month: 1 data points. (*) Duplicate item. Query skipped.

- Variable Operational Expenses, by month: 1 data points. (*) Duplicate item. Query skipped.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Performance Data (XML)

Example performance data in XML format:

7bcebd59-d425-4f29-9ea4-73033d50d515 Executive 5 6 387 5783c13c-673d-4bb9-94e6-6d491c284982 None 76 false false Support Expense, by month 1 0 0 5 118 9 0 76 132 208 None 5 false false Margin, year over year by month 7 0 15 0 49 33 0 5 97 102 None 0 false true Margin, year over year by month 7 0 0 0 0 0 0 0 0 0 None 0 false false Revenue, year over year by month 7 0 1 0 1 33 0 0 35 35 None 0 false true Revenue, year over year by month 7 0 0 0 0 0 0 0 0 0 None 0 false false Variable Operational Expenses, by month 1 0 0 0 2 0 0 0 2 2 None 0 false false Sales by Region 80 0 0 0 0 21 0 0 21 21 None 0 false true Support Expense, by month 1 0 0 0 0 0 0 0 0 0 None 0 false true Support Expense, by month 1 0 0 0 0 0 0 0 0 0 None 0 false true Variable Operational Expenses, by month 1 0 0 0 0 0 0 0 0 0 None 0 false true Variable Operational Expenses, by month 1 0 0 0 0 0 0 0 0 0 None 0 false false Expense, year over year by month 7 0 0 0 1 28 0 0 29 29 None 0 false true Expense, year over year by month 7 0 0 0 0 0 0 0 0 0 2014-03-05T12:43:16.8413716-05:00 2014-03-05T12:43:16.8613716-05:00 2014-03-05T12:43:17.4193716-05:00 2014-03-05T12:43:17.3093716-05:00 0 53 false false 31 13 0001-01-01T00:00:00 0001-01-01T00:00:00 2014-03-05T12:43:16.5943716-05:00 2014-03-05T12:43:14.6713716-05:00 2014-03-05T12:43:14.3723716-05:00 0001-01-01T00:00:00 0001-01-01T00:00:00 2014-03-05T12:43:16.8103716-05:00 2014-03-05T12:43:16.7373716-05:00 2014-03-05T12:43:16.0723716-05:00 2014-03-05T12:43:19.5273716-05:00 128

Related topics


Click to return to: Documentation | Installing and Administering Dundas Dashboard

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.