![]() ![]() Thats the time SSRS renders the processed data with the report elements for the specified output format (PDF, DOCX, HTML, …). ![]() Number of milliseconds spent rendering the report. Thats the time the SSRS gets the results and processes the data based on code and settings (sorting, filtering. Number of milliseconds spent processing the report. Thats the time the SSRS sends the queries to the SQL server, the SQL server executes the queries and sends back the results to the SSRS. Number of milliseconds spent retrieving the data. ![]() The result of this select statement are three very informative columns of the ExecutionLog3 view TimeDataRetrieval ![]() select ItemPath, TimeStart, TimeEnd, convert ( varchar, TimeEnd - TimeStart, 114 ) as Duration, convert ( varchar, dateadd ( ms, TimeDataRetrieval, 0 ), 114 ) as TimeDataRetrieval, convert ( varchar, dateadd ( ms, TimeProcessing, 0 ), 114 ) as TimeProcessing, convert ( varchar, dateadd ( ms, TimeRendering, 0 ), 114 ) as TimeRendering from ExecutionLog3 order by TimeStart desc ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |