Sometimes during the day, the cubes I'm using slow down a lot. A set of
querries that usually takes 1-2 seconds will take 50 or 60 seconds. I'm not
sure if this has to do with the cache or the way sql server works. What
should I look for to see why it's so slow, or to debug this?

One of the problems is that you actually cannot debug.

Lots of issues can be the reason for this:

* network
* front end
* cube architecture (do you have large flat dimensions, are they lots of
empty combinations in your dimensions)
* the way the user queries (do they go down on a very detailed level than
perhaps you need more aggregations)

http://www.microsoft.com/technet/pro.../ansvcspg.mspx


"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote

have you validated the aggregations of your cube?
have you try the usage based optimization wizard?

does it MOLAP cube or ROLAP?

do you test from the same client using the same connectionstring?

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote