locked
Data returns quickly but binding with excel sheet slow RRS feed

  • Question

  • Hi,

      I have stored procedure and used few temp tables inside this sp. It returns data very fast but binding with excel sheet taking more time and some times page can't displayed messages pup-op if multiple session started/ multiple times clicked generate button.

    Database server is SQL server 2012.Resource is looking sound.

    This query is used for generating reports.

    can you please advise what is the issues?

    Regards,

    Thursday, July 16, 2015 6:16 PM

All replies

  • I'd first look at these items:

    • MEMORY on your machine (where Excel is running)
    • ASYNC_NETWORK_IO waits in the SQL data source
    • Possibility of NOT using Excel for reporting and instead using SSRS or Tableau or some other tool that is made for such activities

    I hope you found this helpful! If you did, please vote it as helpful on the left. If it answered your question, please mark it as the answer below. :)

    Thursday, July 16, 2015 6:21 PM
  • Thank you very much!

    I will be looking these steps and reply back asap.

    Regards,

    Thursday, July 16, 2015 6:25 PM
  • I am back again,in SSMS it shows one session ID  even if I clicked two times the report generate report button.

    anyway it would be shown two session ID even though it is slow any idea?

    Regards,

    Thursday, July 16, 2015 6:47 PM