Foglight for Databases dashboard is slow to load, resulting in time outs (4264566)

When navigating to the Databases dashboard, it takes a very long time for the dashboard to load (longer than 5 minutes, for example). Occasionally, the dashboard fails to load, showing timeout errors in the Foglight Console. The issue occurs when using various Internet Browsers (IE6/7, Chrome & Firefox).

SOLUTION 1: Group databases. When grouping databases, less data that will be loaded.

SOLUTION 2: Hide columns that are resource intensive. Resource intensive columns include: Workload, CPU(%), Memory (%) and Disk (%). These columns contain small graphs and need more time/resources to be rendered.

SOLUTION 3: Change the way the Database dashboard collects data by removing the "Upgrade" check on all database agents/hosts:

1. Navigate to the Databases dashboard and, once loaded, expand the right pane on the console with the General, Design and Help tabs.
2. Select the "Design" tab, and select the "Definition" in the lower panel. Click "Inspect" under "Definition."
3. Go to the drop down list and choose "Functions";
4. Search for the function "get Upgrade Required Status" and click "Edit";
5. Enter the line: return "none"; at the beginning of the script;
6. Save the modification