SQL Server Performance dashboard reports

  • BLOB EATER

    SSChampion

    Points: 14604

    Comments posted to this topic are about the item SQL Server Performance dashboard reports

  • Eitan Blumin

    SSC Enthusiast

    Points: 133

    Looks very interesting and a very cool looking feature.

    Will this work even if I don't have a SQL Server 2012 machine? (only SQL 2008 for example)

  • BLOB EATER

    SSChampion

    Points: 14604

    eitan 35333 (8/20/2015)


    Looks very interesting and a very cool looking feature.

    Will this work even if I don't have a SQL Server 2012 machine? (only SQL 2008 for example)

    Hi,

    Yes I have tested it against multiple SQL 2008 SP3 machines. Works well.

  • Eirikur Eiriksson

    SSC Guru

    Points: 182425

    Thank you Arun for this write up, good job.

    😎

  • BLOB EATER

    SSChampion

    Points: 14604

    Thanks for the positive feedback. Makes me motivated to write more.

  • mauriciorpp

    Default port

    Points: 1472

    this was a really great article, that put together some tools previously available but that I never thought of using at the same time. it's great to see the examples applied to a real-world case.

    again I wish there was a button to share these articles directly to WordPress, as a way to bring more audience to SSC and share this knowledge to my humble audience. anyway I will link it back to you for sure.

  • jasona.work

    SSC-Forever

    Points: 49965

    I sincerely hope that I can implement this where I work.

    Really good article, clear, concise, and easy to follow.

    One of my nieces requires a powerchair to get around and is trying to raise the funds to buy one:
    https://www.gofundme.com/f/get-breezy-a-new-wheelchair?utm_source=customer&utm_medium=copy_link-tip&utm_campaign=p_cp+share-sheet

  • aura_muccio

    SSC Rookie

    Points: 31

    This is a great article! I'm trying to implement this right now - is there an .rdl for that main entrance page? I'm not sure how to link the results from the CMS to the rest of the dashboard pages. Thanks!

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Can't wait to try this, thanks.

  • BLOB EATER

    SSChampion

    Points: 14604

    @mauriciorpp & Jasona.work & iwasborn ready - thanks alot for the feedback! Much appreciated!

    @ aura_muccio - I believe I did a quick RDL to hold the entrance page (just based from a simple parameter stored proc)

    Once I have cleaned the code up and added some more comments I am happy to share it.

  • aura_muccio

    SSC Rookie

    Points: 31

    Thank you for the follow up!! Much appreciated!

  • David Stokes

    SSC Veteran

    Points: 235

    Hey Arun, Thanks for putting this out there! I set this up in my environment but when I select a server from the drop down the report shows the CMS server, regardless of which one I select. I am running CMS on a SQL Server 2014 box and my report server (SQL Server 2012) is on a separate SSRS server. Any help in troubleshooting this would be appreciated. Thanks again for your work in getting the word out for this under-utilized tool !

  • BLOB EATER

    SSChampion

    Points: 14604

    David Stokes (8/25/2015)


    Hey Arun, Thanks for putting this out there! I set this up in my environment but when I select a server from the drop down the report shows the CMS server, regardless of which one I select. I am running CMS on a SQL Server 2014 box and my report server (SQL Server 2012) is on a separate SSRS server. Any help in troubleshooting this would be appreciated. Thanks again for your work in getting the word out for this under-utilized tool !

    I will ping you a PM. Cheers

  • w.koster

    SSC Journeyman

    Points: 94

    David Stokes (8/25/2015)


    Hey Arun, Thanks for putting this out there! I set this up in my environment but when I select a server from the drop down the report shows the CMS server, regardless of which one I select. I am running CMS on a SQL Server 2014 box and my report server (SQL Server 2012) is on a separate SSRS server. Any help in troubleshooting this would be appreciated. Thanks again for your work in getting the word out for this under-utilized tool !

    I ended up with the same. Whichever server i select i always get de CMS server. Is it possible that some steps are missing in the article?

  • BLOB EATER

    SSChampion

    Points: 14604

    For each connecting report ( from the main page) you will need to pass in the @servername as an “action”..

    See screen shot.

    This is how I passed in the servername into the datasource within the specific reports so they run within your selected server and not cms :

    ="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=master"

Viewing 15 posts - 1 through 15 (of 30 total)

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