Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning SSRS Performance on large table RE: SSRS Performance on large table

  • February 20, 2015 at 7:24 am

    #1778943

    smanikandan23 (2/20/2015)

    Thanks for the replay,

    I have checked the report execution log, Seams TimeDataRetrievalis greater 🙁

    TimeDataRetrieval | TimeProcessing | TimeRendering | ByteCount | RowCount

    263105 | 57 | 79 | 56481 | 19

    Over 4 minutes for data retrieval, seems consistent with your query being run for the first time.

    But 4 minutes for 19 rows, that seems like a real long time.

    Maybe you should post your table DDL (including indexes), the query and the actual execution plan.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP