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: Tuesday, May 26, 2015 10:10 AM
Points: 13, Visits: 69
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: 2 days ago @ 3:17 PM
Points: 1,867, Visits: 3,662
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.


__________________________________________________________________________________
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
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: Tuesday, May 26, 2015 10:10 AM
Points: 13, Visits: 69
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: 2 days ago @ 3:17 PM
Points: 1,867, Visits: 3,662
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?


__________________________________________________________________________________
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
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: Tuesday, May 26, 2015 10:10 AM
Points: 13, Visits: 69
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: 2 days ago @ 3:17 PM
Points: 1,867, Visits: 3,662
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.


__________________________________________________________________________________
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
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: Tuesday, May 26, 2015 10:10 AM
Points: 13, Visits: 69
Ok, Thank you for your help.... :)
Post #681804
Posted Monday, March 23, 2009 1:53 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:17 PM
Points: 1,867, Visits: 3,662
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...


__________________________________________________________________________________
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
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: Tuesday, May 26, 2015 10:10 AM
Points: 13, Visits: 69
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: 2 days ago @ 3:17 PM
Points: 1,867, Visits: 3,662
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.


__________________________________________________________________________________
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681984
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse