Report Server Diagnostic Reports

  • michael_davis2

    Mr or Mrs. 500

    Points: 521

    Comments posted to this topic are about the item Report Server Diagnostic Reports

  • SQLRNNR

    SSC Guru

    Points: 281243

    This was perfect timing for me. I was just looking for something to help me with the very topic.

    Thanks for the article.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Franz_K

    SSC Enthusiast

    Points: 106

    Skripts are really great!

    Is there a posibility to publish them automatically on a SharePoint Server 2007?

    Greetings

    Franz

  • roger_os

    SSC Eights!

    Points: 831

    This is perfect timing for me too, thankyou!

    What I would really like is to see the stored procedure name that each report uses, anyone know how to get that?

    TIA, Roger

  • christoph.mueller

    SSC Veteran

    Points: 238

    Hi Michael

    I've just deployed your SSRS Diagnostics Report Pack to SSRS 2005 and also to a SSRS 2008 ReportServer.

    Yes, the schema is different, but you can open the report in visual studio 2008 and it is converted automatically.

    Works great, thanks for your work.

  • sql_lock

    SSCrazy Eights

    Points: 9373

    Works perfect for me on 2005 and 2008 (via SSMS)... Top set of reports!

  • John McC

    Hall of Fame

    Points: 3410

    Great work. Thanks

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • NbleSavage-393985

    Mr or Mrs. 500

    Points: 596

    Great article. .zip file with source code does not seem to be working?

    Peace.

    - Savage

  • Franz_K

    SSC Enthusiast

    Points: 106

    NbleSavage-393985 (2/4/2010)


    Great article. .zip file with source code does not seem to be working?

    Peace.

    - Savage

    *.zip file works perfectly. 🙂

  • NbleSavage-393985

    Mr or Mrs. 500

    Points: 596

    Franz_K (2/4/2010)


    NbleSavage-393985 (2/4/2010)


    Great article. .zip file with source code does not seem to be working?

    Peace.

    - Savage

    *.zip file works perfectly. 🙂

    Still cannot dload....attempts to capture the .zip as a stream / octect...

    Will keep trying, must be on my end.

    - Savage

  • Kev Riley

    SSCrazy Eights

    Points: 9026

    Excellent stuff!

    Have downloaded, installed, and now ready to play. Thank you for sharing these.

    Kev

  • David-Leibowitz

    Mr or Mrs. 500

    Points: 580

    Several points to note:

    1. 2005 is different than 2008 in schema and the type of metrics available. 2008 has more information.

    2. If your solution does not use a datawarehouse and goes directly to the ezecutionlog, the usage metrics are only as good as the history. The default is 60 days.

    A solution exists on codeplex called sqlscrubs to extract all of that information from reporting services 2008 to drive actionable report optimization. It includes the necessary datawarehouse, ssis package and set of starter reports.

    Http://scrubs.codeplex.com

    .

  • denglishbi

    SSCrazy Eights

    Points: 8831

    Very nice article and great job on the reports. Wasn't sure if you were aware of it at all, but with the SSRS Samples on CodePlex there is an SSIS package and Reports that you can leverage, Report Execution Log Files. Doesn't provide everything you have provided, but you might want to check it out if you haven't seen this before. The only reason that you would want this is because you will want to offload the Execution information since the default setting is to only keep 60 days of history.

    There are other Report Packs available for SSRS 2005 that you can check out here on the Microsoft downloads SQL Server 2005 Report Packs.

    Thanks for sharing your work. Once again very nice.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • TheSQLGuru

    SSC Guru

    Points: 134017

    Thanks for sharing your work!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • INNOCENT GUMBO

    Old Hand

    Points: 378

    Michael, we used to fight with Develpoers on why the report has failed. Now you can see on the Subreport "ReportErrors". Now we can see who went on to give himself power to run and edit reports.

    A very nice piece of Work. Especially on your introduction of how you used to take time to establish the problem, now you have made a master piece which can manifest within seconds.

    I did test with SQL 2005 and it seems as if I did develop these reports on my own!!!:-P

    If possible just give me any hints about Reporting Services. I am not much concentrating on Reporting on my Work but today I have changed my mind.

    Michael thanks for changing other people's minds also. I will be on Reporting from now on.

    Thanks

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

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