Re: Performance of Cube request

Tech-Archive recommends: Fix windows errors by optimizing your registry

have you created partitions?
have you used the usage based optimisation wizard?

do you use AS2000 or 2005?

"Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CCA4B78D-D0E8-45B9-91A6-051667563A95@xxxxxxxxxxxxxxxx
> We use count, sum, avg, min ,max, etc.
> We use queries that involved caclualted members and simple pivots
>
> "Denny Lee" wrote:
>
>> In general, you're going to need to experiment to see how to improve the
>> performance, a good guide for this is:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx
>>
>> There are quite a few properties to be talking about as well as design
>> considerations. While you have few dimensions, are you measures distinct
>> count or aggregate (count, sum, etc.) in nature? What type of queries
>> are
>> you trying to improve - ones that involve caclualted members or simple
>> pivots?
>>
>> --
>> HTH!
>> Denny Lee
>> <dennyglee_at_hotmail_dot_com>
>>
>> Blog at:: http://spaces.msn.com/members/denster/
>>
>>
>>
>> "Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:0B8BB4EB-3F3E-49A7-B08C-C8089B8FA7DA@xxxxxxxxxxxxxxxx
>> > We have a cube that is 40 gigs.
>> > We have a lot of data and very few dimensions.
>> > We have performance issue on Read Disk queue lengh.
>> > How should we setup the properties of the Analysis server to have the
>> > best
>> > performance ? ( process, threads, etc.)
>> >
>> > Thanks.
>>
>>
>>


.

Relevant Pages

  • Re: SQL 2005 AS Date Question
    ... Sum is correct. ... wrong but the aggregates for year are incorrect.. ... All my other dimensions work fine.. ... > Deepak Puri ...
    (microsoft.public.sqlserver.olap)
  • RE: Simplification of Matrix
    ... To verify, the first 4 would be included for any totals involving July 2008, ... have the matrix simplified to sum for months. ... under two dimensions. ... When I see a table with row headers and column headers such as you ...
    (microsoft.public.excel.misc)
  • Re: Operating on multi-dimensional arrays
    ... multiple dimensions of multi-dimensional arrays. ... I like the second way because I only have to use sum once, ... and I'm working with anywhere from 3D to 6D arrays. ...
    (comp.soft-sys.matlab)
  • Is Solve_order the way to do a 2-pass aggregation?
    ... Let's say we have a cube with these dimensions: ... day at any location or product, all we have to do is aggregate with SUM ... total inventory by month, and each month should be an average of the ... Am I searching down the wrong path? ...
    (microsoft.public.sqlserver.olap)