dbTalk Databases Forums  

query performance when rebuilding OLAP cache

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss query performance when rebuilding OLAP cache in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
c.marchi
 
Posts: n/a

Default query performance when rebuilding OLAP cache - 11-02-2006 , 08:17 AM






Hi all,
I have a MOLAP cube with five measures group and my goal is process all
measures (with XMLA script) every five minutes. I don't want to use the
Proactive Caching. I don't believe that the service works fine. So,
when I execute the xmla script, the query performance are good, but
when the rebuilding cache is started, the query performance are very
slow.

I think that when rebuild cache is running, the query would have to be
executed on the old cache.

All Suggestions are appreciate!

CristianM


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.