Tuesday, 27 December 2011

SSRS ExecutionLog For Performance

SSRS Executing log table contains  important metrics for performance.It allows to see the reports execution results which contains information aboutthe user who executed reports,the amount of time it has taken  for data retrieval,time taken to process,time taken to render,no of bytes,number of rows  ,time the report started execution,time the report completed etc .These metrics can be further analysed ,suppose we can use the no of rows and bytes to check which report is giving large number of records ,also the execution time for data retrievel and further we can use other performance tools to look into the details of  query if there is any other issues such as blocking .


No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Power BI Report Server

Power BI Report Server  is a new product which can be used to host both Power BI reports and SSRS reports. Currently beta version is ava...