Post reply

SQL Server Performance dashboard reports

  • August 19, 2015 at 10:47 pm

    #310999

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

  • August 20, 2015 at 2:35 am

    #1821283

    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)

  • August 20, 2015 at 2:41 am

    #1821286

    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.

  • August 20, 2015 at 3:57 am

    #1821316

    Thank you Arun for this write up, good job.

    😎

  • August 20, 2015 at 4:11 am

    #1821320

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

  • August 20, 2015 at 5:55 am

    #1821347

    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.

  • August 20, 2015 at 5:57 am

    #1821348

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

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

  • August 20, 2015 at 7:28 am

    #1821378

    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!

  • August 20, 2015 at 8:14 am

    #1821415

    Can't wait to try this, thanks.

  • August 20, 2015 at 10:17 am

    #1821470

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

  • August 20, 2015 at 10:41 am

    #1821480

    Thank you for the follow up!! Much appreciated!

  • August 25, 2015 at 9:06 am

    #1822224

    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 !

  • August 25, 2015 at 10:59 am

    #1822275

    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

  • August 26, 2015 at 11:20 am

    #1822565

    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?

  • September 3, 2015 at 2:18 am

    #1824205

    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 29 total)

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