Re: AS 2005 slowness...

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

partitionning is good with large tables to improve the process performance
and the query performance.
regarding your hardware, for less then 1million of rows, don't loose to many
time on this
after, try to spread your largest tables into partitions.

where do you store the tempdb database?
how many memory is really consumed by SQL and AS?
have you activated the /3Gb switch in the boot.ini?

x64 servers really help the memory management and scalability.; can you
switch your server to this version?

<ggroups@xxxxxxxxxxxxxxx> wrote in message
news:1154090453.952077.320820@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: AS 2005 slowness...
    ... I'll take a look at creating a couple of partitions - as most of the ... Am not sure where the tempdb is - most likely on the same disk as SQL ... Server and AS, although this disk is cheap-wrt-IO cost, so I'd hope ... Reported memory consumption is 1.8GB for AS, ...
    (microsoft.public.sqlserver.olap)
  • Re: sunmanagers digest, Vol 1 #2105 - 7 msgs
    ... >This is a logical disk. ... The question is whether those pre-defined partitions ... >are because of something Sun is doing, or if its something EMC is doing. ... >> server and configuration server, image server is the same server. ...
    (SunManagers)
  • Re: SBS 2003 Program Files Partition
    ... let me tell you something about the server. ... RAID 1 for mirroring the disks. ... When I was talking about different partitions I had in mind that you would ... have less trouble with disk fragmentation (since the most write accesses ...
    (microsoft.public.windows.server.sbs)
  • Re: High memory usage (*HELP*)
    ... Low on virtual memory does not necessarily mean anything with regard to disk ... If your system uses all the available RAM, ... acceptable for a server to put all of its available RAM to use. ...
    (microsoft.public.windows.server.sbs)
  • Re: Performance
    ... The server is set up with Raid 0 for the system and Raid 0+1 for the D ... rest in the D: (make sure D: is another different physical hard disk). ... The physical memory has available 5029150and stays pretty constant. ...
    (microsoft.public.windows.server.general)