marla
Uploaded by
14 SLIDES
285 VUES
140LIKES

Understanding SSRS Reporting: Insights from Rick Krueger and Dave Valentine

DESCRIPTION

Join Rick Krueger (@DataOgre) and Dave Valentine (@IngeniousSQL) in this comprehensive session on SQL Server Reporting Services (SSRS). Discover the intricacies of Report Server databases, including ReportServerTempDB and ExecutionLog functionalities. Learn best practices for managing report execution and insights on report storage. The agenda covers current activities, cached reports, the RSExecutionLog, and SQL Server 2008 R2 features. Engage in discussions and get your questions answered by the experts in the field.

1 / 14

Télécharger la présentation

Understanding SSRS Reporting: Insights from Rick Krueger and Dave Valentine

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SSRS: Reporting on Reports Rick Krueger (@DataOgre) Dave Valentine (@IngeniousSQL)

  2. Public Service Announcement: Networking Rick Krueger • Twitter: @DataOgre • Blog: www.premierapps.com • Email: rick@premierapps.com Dave Valentine • Twitter: @IngeniousSQL • Blog: www.IngeniousSQL.com • Email:Dave.Valentine@IngeniousSQL.com Dave Valentine (@IngeniousSQL)

  3. Agenda • ReportServerTempDB & ReportServer • ExecutionLog3 • RSExecutionLog • Reports • Wrap Up Dave Valentine (@IngeniousSQL)

  4. ReportServerTempDB • Current Activity • On Demand Reports • Cached Reports Dave Valentine (@IngeniousSQL)

  5. ReportServer • Main store for Reporting Services • Completed Report Execution • ExecutionLogStorage (don’t query, use views) • ExecutionLog (backward compat) • ExecutionLog2 (SQL 2008) • ExecutionLog3 (SQL 2008 R2) • Not all Report Execution is logged Dave Valentine (@IngeniousSQL)

  6. ExecutionLog3 • TimeStart • TimeEnd • TimeDataRetrieval • TimeProcessing • TimeRendering • UserName • ByteCount • RowCount • AdditionalInfo • InstanceName • ItemPath • Source • RequestType • Format • Parameters • ItemAction • Status • ExecutionId Dave Valentine (@IngeniousSQL)

  7. RSExecutionLog • CodePlex: Server Management Sample Reports for 2005 (10 reports) and 2008 (3 reports) • http://msftrsprodsamples.codeplex.com/ • Scripts to create supporting object, SSIS package, and sample reports • Download not available for 2008 R2 Dave Valentine (@IngeniousSQL)

  8. RSExecutionLog: Database Diagram Rick Krueger (@DataOgre)

  9. RSExecutionLog: Dimension Values Rick Krueger (@DataOgre)

  10. RSExecutionLog: SQL 2008 R2 • Download not available for 2008 R2, but upgrade path has been documented by others: sqltwist.com/archives/197 • Documentation not quite right (for my box), so providing download • Scripts for objects • SSIS Package Rick Krueger (@DataOgre)

  11. Reports: Canned Samples Rick Krueger (@DataOgre)

  12. Reports: Eleven (bit.ly/9SPUYJ) Dave Valentine (@IngeniousSQL)

  13. Wrap Up • ReportServerTempDB and ReportServer • RSExecutionLog • Eleven • Five reports as of August 2012 • Eleven reports by December 2012 • SQL 2012 version by December 2012 Dave Valentine (@IngeniousSQL)

  14. Questions & Discussion Rick Krueger • Twitter: @DataOgre • Blog: www.premierapps.com • Email: rick@premierapps.com Dave Valentine • Twitter: @IngeniousSQL • Blog: www.IngeniousSQL.com • Email:Dave.Valentine@IngeniousSQL.com Dave Valentine (@IngeniousSQL)

More Related