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 ««123»»

Real-Time Tracking of Tempdb Utilization Through Reporting Services Expand / Collapse
Author
Message
Posted Monday, March 23, 2009 12:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result.

I double checked the DB and there are two table with no data:

ExecRequests
TempdbSpaceUsage_Mean_StdDev
Post #681750
Posted Monday, March 23, 2009 12:57 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result.

I double checked the DB and there are two table with no data:

ExecRequests
TempdbSpaceUsage_Mean_StdDev


I think I know what may be wrong. Pls start the job titled "DBA - Tempdb Usage - Calculate Stats, Prune Tables". This job must run at least once before you start collecting data. I need to make sure this step is added to the SuppMaterial readme doc.

I hope this solves the problem, if not, pls let me know.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681754
Posted Monday, March 23, 2009 1:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
I manually ran the job and then checked the log file and the job has been running every hour since I created it last Friday. Same thing with the Monitor job - it has been running every minute since last Friday.
Post #681762
Posted Monday, March 23, 2009 1:27 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result.

I double checked the DB and there are two table with no data:

ExecRequests
TempdbSpaceUsage_Mean_StdDev


The fact that these 2 tables are empty just means that there have been no major peeks in the number of version-store/mixed-extent pages during this time. I forgot to ask you, are you having this problem in BIDS or IE or both?


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681783
Posted Monday, March 23, 2009 1:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
Both, it is blank locally and on the report server.
Post #681784
Posted Monday, March 23, 2009 1:48 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
scotta_miller (3/23/2009)
Both, it is blank locally and on the report server.


I will run the Supp Material code later today and see if I can reproduce the issue. Will send out an update later.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681800
Posted Monday, March 23, 2009 1:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
Ok, Thank you for your help.... :)
Post #681804
Posted Monday, March 23, 2009 1:53 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result.

I double checked the DB and there are two table with no data:

ExecRequests
TempdbSpaceUsage_Mean_StdDev


No problem, we will get to the bottom of this one way or another...


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681813
Posted Monday, March 23, 2009 2:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. I guess I am used to seeing data populate when the report is ran. I changed the default Flag value to 1 so when the report runs, data is always populated for the default server and then subsequent servers as you click through them.


Thanks for your help, you may consider outlining this or defaulting the Flag to 1.

Post #681877
Posted Monday, March 23, 2009 5:15 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
scotta_miller (3/23/2009)
Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. I guess I am used to seeing data populate when the report is ran. I changed the default Flag value to 1 so when the report runs, data is always populated for the default server and then subsequent servers as you click through them.


Thanks for your help, you may consider outlining this or defaulting the Flag to 1.



Yes, thank you for pointing this out. In fact, come to think of it, I should have designed the report so that it opens up for the default server to save the user from doing additional clicks. Glad it is now working for you.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681984
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse