none
rs.exe invoking is slow

    Question

  • Hi SQL Guru's

    I have a automation SQL procedure which calls rs.exe using xp_cmdshell and render the report on the same reporting server as excel.  I execute the command from SSMS as below

    select GETDATE()
    exec master..xp_cmdshell 'rs -i\\ReportSrv1\GeneratedFiles\RunReport.rss -shttp://ReportSrv1/ReportServer/reportExecution2005.asmx?WSDL -e Exec2005 -vFileName="f:\GeneratedFiles\test.xls" -vReportPath="/Commissions/Report1" -vExportFormat="EXCEL" -vMimeType="MS-EXCEL" -vRevPer="201312" -vSite="05818" -vSiteEntry="0" '
    select GETDATE()

    Infrastructure:
    Report ServerName: ReportSrv1
    Location: Same report server location, f:\ drive
    Reports connecting to Server/Database: Srv1->Commart

    Ran parallel SQL profiler to Srv1->Commart.

    Output:
    2014-02-06 11:28:30.193
    The command completed successfully
    NULL
    2014-02-06 11:28:40.907

    Output of Profiler Trace:
    Start Time: 2014-02-06 11:28:38.900
    End Time: 2014-02-06 11:28:40.040

    Please see there is a signification delay of 8 seconds to make the database connection, which makes my report to complete in 10 seconds including the database calls.

    Why would that 8 second delay happens, I will be running the same report for 3000 parameters which is consuming lot of time although the database calls are pretty stable.



    Thanks,
    Ganesh



     


    Ganesh

    Thursday, February 06, 2014 5:56 PM

Answers

  • http://dba.stackexchange.com/questions/32918/sql-server-reporting-services-slow-totaltimedataretrieval-fast-executereadertime

    Based on the above link, what is causing the rendering time to go that high, I have tested the same thing in 2 different boxes and I end up wasting 7 to 8 seconds. 


    Ganesh

    Thursday, February 06, 2014 9:34 PM

All replies

  • http://dba.stackexchange.com/questions/32918/sql-server-reporting-services-slow-totaltimedataretrieval-fast-executereadertime

    Based on the above link, what is causing the rendering time to go that high, I have tested the same thing in 2 different boxes and I end up wasting 7 to 8 seconds. 


    Ganesh

    Thursday, February 06, 2014 9:34 PM
  • Hi Ganesh,

    Was the problem resolved? If it is resolved, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, February 10, 2014 1:57 AM
  • it's not yet resolved, I am finding way to invoke the SSRS through SSIS and check to see if that helps.


    Ganesh

    Monday, February 10, 2014 5:07 PM