Speed performance problem in generating reports | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Speed performance problem in generating reports

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