Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    India
    Posts
    4

    Unanswered: Optimizing MS OLAP Cube build time and response time

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

  2. #2
    Join Date
    Feb 2003
    Posts
    109

    uh use a better design

    what 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..
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •