Re: Sudden drop in speed after adding some records. Why?

From: Jéjé (willgart_at_BBBhotmailAAA.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 00:12:32 -0400

what the usage analysis says?
does the query takes a lot of time to be processed by the server?
setup the log query interval to 1 in your servre properies to log every
query sent to your cubes.
play with the cube, and see the results with the usage analysis.
if the response time is lower than your display time then the problem is at
the render level. (for example, the rendering process takes 1minute and the
server process time takes only 5 seconds, then too many calculations are
done by the client)
Try a tool like www.reportportal.com (there is a free version and an
evaluation version) this tool support the paging feature, so you'll display
only 100 rows (or other number) by page.

Try to play with the client connection string to insure you use server side
calculation instead-of client side. (the client can retrieve more rows from
the server to calculate the measures at the client side,

How many members has your biggest dimension?
how many members are displayed in OWC (or other tool) at the same time?

read this article:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx

maybe the section : Optimizing Clients for Slow Network Connections

"Polly" <Polly@discussions.microsoft.com> a écrit dans le message de news:
3585EFA1-5790-41B2-A4A7-A47000232CAA@microsoft.com...
> Jéjé,
>
> First of all, thanks for your suggestion.
>
> Before adding these 200,000 records, my fact table has over 10,000,000
> reocrds.
> I have done a full process in both dimensions and cubes.
> How to setup the targeted number of rows in your cube?
> I am using Excel 2003. Therefore, it can show about 65000 rows I think.
> My calculated members are only "Net amount (Gross Amount - Discount
> Amount)"
> and "Unit Price (Net Amount / Quantity)". They only involve simple
> calculation and measures in the cube. Therefore, I don't think slow speed
> is
> due to complexity of my calculated measures.
> Also, I discovered that when I drap the result in cube editor and OWC. The
> speeds are extremely slower (it hasn't finished job more than one hour)
> than
> I expected.
>
> What happen to my cube?
>
> Polly
>

Relevant Pages

  • Re: High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... We have encountered similar problems not limited to Excel, but every client. ... occur when there are many dimensions nested on each other on a single axis ... > Performance Guide to optimize the query, the cube, the server, etc. ... > While the query was grinding, the server was doing absolutely nothing. ...
    (microsoft.public.sqlserver.olap)
  • RE: LDAP query for xerox 3545 printer/scanner blocked by SBS 2003?
    ... Client and printer pointing to SBS for DNS ... LDP query from another workstation was successful ... Step2:Please ensure the DNS on workstation is pointed to SBS server. ... Monitor will capture some packets which pass through this interface. ...
    (microsoft.public.windows.server.sbs)
  • Re: Performance Benchmarks?
    ... Are attribute relationships defined properly on the dimensions? ... If you run Profiler against the server, how long is spent in "Query ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • Re: public distributed filesystem
    ... You have a simple server which keeps track of client ... >>whether a peer has honestly kept your data block ... respond to any checksum query is to essentially store ...
    (comp.os.linux.misc)