Re: Analysis Manager Operations extremely slow

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 10:42:06 -0700

>From the sizing you've described so far I am very surprised that you are
seeing AM slow down like that. Are there any places where you have hundreds
of objects, e.g. you've created hundreds of security roles; or hundreds of
partitions in one of your cubes?

A couple of other questions.
Are you running AM remotely or on the server itself?
Are you using a domain account when running AM or local administrator?
I ask this because one of the other possible sources of the "slowness" could
be domain authentication. 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MurthyJ" <MurthyJ@discussions.microsoft.com> wrote in message
news:2D320B0D-3DB9-4484-9F42-F2DDA1F4C216@microsoft.com...
> Hi
>
> We are running SQL Server 2000 Analysis Services SP3, currently in
> development. Our data warehouse source is in Oracle 9i. We have about five
> cubes each with about 9 regular dimensions, 1 virtual dimension. One of
the
> regular dimensions has five different hierarchies, three of them defined
as
> virtual. Each of the cubes have many partitions. A lot of these dimensions
> are defined as shared. The cubes themselves are not bad for browsing,
> although we haven't loaded all of the data yet. The dev machine is running
> Windows 2003 Server, has 2GB of memory.
>
> So, we have a pretty sizable amount of information that is read from and
> written to the repository whenever we attempt to edit a cube or a
dimension.
> However, things have gotten extremely slow now, Just clicking edit on a
cube
> takes two of minutes or more before it brings up the window. Some of the
> changes we may do on a shared dimension (such as setting a default member
for
> time) are making the analysis manager to simply hang (never returns).
>
> I checked the mdb repository size to be close to 10MB. Hoping that it may
> improve things, I migrated the repository to a local SQL Server instance
> blank database (not msdb). It has not improved anything at all.
>
> I am hoping someone can be give me some pointers to look at other things
to
> fix these problems.
>
> I appreciate your suggestions/ideas.
>
> Thanks
> Murthy.

Relevant Pages