Real-Time Tracking of Tempdb Utilization Through Reporting Services

  • Marios Philippopoulos

    SSC Guru

    Points: 57030

    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.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • scotta_miller

    SSC Journeyman

    Points: 83

    Ok, Thank you for your help.... 🙂

  • Marios Philippopoulos

    SSC Guru

    Points: 57030

    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... 🙂

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • scotta_miller

    SSC Journeyman

    Points: 83

    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.

  • Marios Philippopoulos

    SSC Guru

    Points: 57030

    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.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • Fraggle-805517

    SSCrazy Eights

    Points: 8907

    General question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012. Being blunt, I am lazy and wanted to ask before spending time trying to figure everything out.

    Fraggle

  • Marios Philippopoulos

    SSC Guru

    Points: 57030

    Fraggle-805517 (9/6/2012)


    General question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012. Being blunt, I am lazy and wanted to ask before spending time trying to figure everything out.

    Fraggle

    Hi,

    I have a SQL-2008 version, if you are interested.

    Haven't updated to 2012 yet.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 7 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply