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?
    Thanks

    Wins
  2. eralper New Member

    Hi,

    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.

    Eralper
    http://www.kodyaz.com



    Eralper
    http://www.kodyaz.com

Share This Page