Hi,
Can someone highlight some of the common methods to improve and optimize the CUBE BUILD TIME and RESPONSE TIME using MS OLAP Services with SQL Server?
Regards,
Omkarwhat kindof dataset are you trying to load?
never use ROLAP, unless you have to.
do analysis services on a dedicated server.
www.sqlserverperformance.com
a lot of good tips are there..
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment