dbTalk Databases Forums  

usage based optimization wizard slow to start...

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


Discuss usage based optimization wizard slow to start... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeje
 
Posts: n/a

Default usage based optimization wizard slow to start... - 05-10-2006 , 10:48 PM






Hi,

When I use the usage based optimisation wizard in AS2005, starting the
aggregation evaluation process is long.
when I click "Start" in the last page of the wizard there is a delay between
1 and 5minutes before the evaluation starts!!!

then the wizard identify the aggregation correctly to reach the % set in the
page.

during these 1-5minutes nothing appends on the server side. the CPU is at 0%
used
Bigger the cube is longer the delay is!

also, if I change the % value AFTER I have evaluated the aggregations (for
example changing from 30% to 50%), the wizard restarts the aggregation
evaluation from 0 instead of doing a gap between the 30% allready evaluated
to the 50% the new target.

what's appends?

what can I do?

thanks.

Jerome.



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.