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 .
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...
-
This article defines about Slowly Changing Dimension 3 ,the uses of slowly changing dimension Type 3 and its implementation using SSIS . ...
-
SSRS metada contains wealth of information which can be usefull under varieous circumstances , but extracting that informatio...
-
Data Depulication using SSIS 2012 The De Duplication componants used in this demo are Sort Lookup FuzzyLookup FuzzyGrouping ...
No comments:
Post a Comment
Note: only a member of this blog may post a comment.