I have a challenge in displaying the database server health statistics with a minimum refresh rate (about 5-30 seconds). There are about 6 datasets for which I will be using 6 different tables(which have linear gauges) for dispaly. 4 of these 6 datasets take quite a bit of time to query(about 2mins). Is there another efficient way of doing this as the report is becoming slower and slower as I keep adding more tables into it.
Would dashboarding be faster? I have never done dashboarding before and I am just assuming that a dashboard drives the datasets as different reports hence faster rendering time.
I would appreciate you guys taking time to answer my questions.