Multiple tables in a Report

• DataEnthusiast

  Right there with Babe

  Points: 732

  More actions

  April 10, 2013 at 6:40 pm

  #270954

  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.

• jerry-621596

  SSCertifiable

  Points: 6096

  More actions

  April 11, 2013 at 3:37 pm

  #1605796

  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.