Re: AS 2005 slowness...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It's an x32 server, two dual-cores, CPU is not a problem, although 3GB
memory limit could be.

None of the disks are even close to being full, so it's not that,
unfortunately.

The source DB is admittedly on the same server, but the memory / CPU
configuration together with the disk array shouldn't make this _that
much_ of an issue.

Each of the ten measures groups has one partition. This is a
potentially bad thing, right?

Jéjé wrote:
do you use x32 or x64 server?
have you identify which disk is full? (if there is a full disk)
where is the source database? on the same server?

do you use partitions?

<ggroups@xxxxxxxxxxxxxxx> wrote in message
news:1154077156.120526.157250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,

We have a cube (of approximately 500 dimensions/attributes/hierarchies,
closer to 30 true dimensions), and ten measure groups.

This cube is running on AS 2005 Enterprise, on Windows 2003 Enterprise,
with /3GB in the boot.ini. Disk IO is not a problem - we have 24 disks
running side-by-side, with data being striped across all 24. The
server has 8GB physical RAM.

We frequently get 'not enough storage' problems, and generally sluggish
performance, when administering / modifying the cube through SSMS,
whether this be on the server itself or remotely. The most notable
place this happens is in the 'Design Aggregations Wizard', which will
frequently either return with 'not enough storage', or will take five
or so minutes just to get to the 'Initializing...' phase.

I'm interested in knowing whether we're alone in experiencing these
problems, or whether they're generally accepted by the current user
base (or perhaps, generally 'tolerated').

Any suggestions as to how to fix up any issues appreciated!

Regards,

Will.


.

Relevant Pages

  • Re: ASP.Net Performance Problems
    ... The stress testing was conducted over a week long period using the Microsoft ... the webserver and the database server. ... Disk I/O - OK ... CPU - overloaded ...
    (microsoft.public.dotnet.distributed_apps)
  • hai...find me a solution in M5000 server
    ... series server. ... B B B B B i want to do install one more solaris Over there. ... Solaris cannot see all drives on Areca RAID controller ... popped it (a single disk at this point) into machine1. ...
    (SunManagers)
  • Re: sunmanagers Digest, Vol 22, Issue 12
    ... series server. ... B B B B B i want to do install one more solaris Over there. ... Solaris cannot see all drives on Areca RAID controller ... popped it (a single disk at this point) into machine1. ...
    (SunManagers)
  • Re: Disk Array Usage
    ... > server, and the rest are web, file and app servers. ... I see an array as a massive storage ... > than a disk array, why not have an actual server with a ton of space? ... If you have a number of disks which can be attached to by several machines ...
    (comp.sys.sun.hardware)
  • Re: ASP.Net Performance Problems
    ... for the high CPU usage. ... > the webserver and the database server. ... > Disk I/O - OK ... >> a profiling tool during the test to determine which class is the culprit. ...
    (microsoft.public.dotnet.distributed_apps)