Groups | Blog | Home
all groups > sql server reporting services > february 2005 >

sql server reporting services : Speed of reports with OLAP


Cindy Lee
2/3/2005 4:05:09 PM
I'm doing probably 10 -15 MDX queries for each report.
I got a big difference in speed when the database cube were put on the same
machine as reporting services and IIS.

With the Database and Reporting services on the same machine the report
takes 10 seconds. When they are on different machines, the report takes 1
min.

What should I take to solve this problem? And Ideas?

Cindy Lee
2/3/2005 6:11:06 PM
Is it possible that it's because don't have SQL Server Pro? and just the
regular edition?


[quoted text, click to view]

AddThis Social Bookmark Button