Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple tables in a Report Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 6:40 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 11:41 AM
Points: 21, Visits: 155
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.
Post #1441078
Posted Thursday, April 11, 2013 3:37 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:58 PM
Points: 367, Visits: 615
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.
Post #1441504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse