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.