April 10, 2013 at 6:40 pm
Hey guys,
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.
Thank you.
April 11, 2013 at 3:37 pm
I would look into a tool such as the Red Gate SQL Monitor to do what you are looking to do. Very slick and efficient.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply