SQL Server Performance

Speed performance problem in generating reports

Discussion in 'SQL Server Reporting Services' started by Wins, Jan 6, 2005.

  1. Wins New Member

    Hi, I have performance problem in term of speed in geenerating reports. sometimes it takes about 15 minutes. Can somebody pointed out some hints of how to improve this matter?

  2. eralper New Member


    Did you check the speed of the sql statement maintaining the data to the report while running on the wuery analyzer?

    If there is not a big difference between the two, then it is better to go over tuning the sql statement.

    Also it is an alternative and will be the best solution to take snapshots of the report if it is possible. So you will not run it each time you need it.



Share This Page