Performance tuning Dashboards, Widgets, and Reports

[Dan_Kane]

A common question that comes up is some variation of: "What is the limit for the dataset size when running reports or PA Dashboards?" Technically there is no limit, because the size of the dataset is just one of the important factors to consider. While massive tables (10 million+ records) will almost always return query results slowly, there are several steps you can take to improve performance on any Dashboard, Report, Widget, or Data Visualization. In some cases, you can improve a dashboard from loading in 60 seconds to loading in 5 seconds. Other scenarios can improve the amount a time a Performance Analytics data coillection job runs. Data collection jobs are intended to run overnight. We've seen data collections of massive data sets take days, which is never acceptable. In those cases, we can often improve the data collection from multiple days to multiple hours, which can be acceptable for overnight jobs.

Attached is a presentation used to summarize most of the techniques used to improve performance of dashboards, reports, widgets, and data visualizations.