<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Marios...
»
Real-Time Tracking of Tempdb Utilization...
22 posts, Page 2 of 3
««
1
2
3
»»
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Rate Topic
Display Mode
Topic Options
Author
Message
scotta_miller
scotta_miller
Posted Monday, March 23, 2009 12:52 PM
Grasshopper
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
Marios Philippopoulos
Marios Philippopoulos
Posted Monday, March 23, 2009 12:57 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
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 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
scotta_miller
scotta_miller
Posted Monday, March 23, 2009 1:07 PM
Grasshopper
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
Marios Philippopoulos
Marios Philippopoulos
Posted Monday, March 23, 2009 1:27 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
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 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
scotta_miller
scotta_miller
Posted Monday, March 23, 2009 1:31 PM
Grasshopper
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
Marios Philippopoulos
Marios Philippopoulos
Posted Monday, March 23, 2009 1:48 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
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 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
scotta_miller
scotta_miller
Posted Monday, March 23, 2009 1:50 PM
Grasshopper
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
Marios Philippopoulos
Marios Philippopoulos
Posted Monday, March 23, 2009 1:53 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
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 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
scotta_miller
scotta_miller
Posted Monday, March 23, 2009 2:53 PM
Grasshopper
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
Marios Philippopoulos
Marios Philippopoulos
Posted Monday, March 23, 2009 5:15 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
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 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 »
22 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
