Monday, November 28, 2011

Executionlog of SQL Azure Reporting reports .

In one of my previous blogs I wrote about performance tips to improve the performance of your SSRS reports. In this blog I wrote about the 3 different performance elements during the execution of a report:
  1. Time to retrieve the data (TimeDataRetrieval).
  2. Time to process the report (TimeProcessing)
  3. Time to render the report (TimeRendering)
Total time = (TimeDataRetrieval) + (TimeProcessing) + (TimeRendering)

As of SQL Server 2008 R2, this 3 performance components are logged every time for which a deployed report is executed. This information can be found in the table Executionlog3 in the ReportServer database. In SQL Azure Reporting you can't access the ExectionLog3 table, however it is still possible to get the contents of this table. To get the contents of this table do the following:

  1. Login to the Azure Management Portal.
  2. Select Reporting
  3. Select your reporting subscription.
  4. Press the Download Execution Log button in the top of the management portal.
  5. Select the date you want to export.
  6. Open the downloaded CSV file in Excel.

1 comment:

l43gmv1js1 said...

An Israeli startup, Plantish hopes to rework the food industry, particularly how we eat fish. Mid-America Apartment Communities and Terreno Realty are seasoned performers with stocks trading at cut price costs. Underwear for Men It's the third giant workplace property occupied by UnitedHealth Group or a subsidiary that's recently hit the leasing market.