Re: Help with large Dimension

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

we talk about millions not billion
you have not reached the limits.
you certainly suffer memory issues and/or disk issue.

there is some performance counters to track the memory used by SSAS.


"entaroadun" <johnny.c.kwan@xxxxxxxxx> wrote in message news:1190951110.618610.198490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
This sounds like a physical barrier with the data structure and index
used to store the attribute. There's probably a very real size limit,
and the order of the keys arriving from the DB are causing thrashing.
(Just a guess.) Have you monitored network and disk I/O? How about
pmem vs. vmem?

On Sep 27, 8:28 pm, "Jeje" <willg...@xxxxxxxxxxx> wrote:
SQL Server runs queries to retrieve only used
so there is no impact if your table / view returns 100 columns, only the 28
used should be loaded.

you can verify this by taking a look at the SQL statement executed by SSAS
(expend the process tree during the process step to see the queries)

another option you should consider is the number of queries which can SSAS
runs against the database.
in the DB connection dialog box there is an option which is the number of
queries authorized in parallel for this connection.

"rufhowse" <rufho...@xxxxxxxxx> wrote in message

news:1190935277.901988.241940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> One more question,

> Oracle is the data source. The source table has over 100 columns. I
> am only using 28 of them in the record detail dimension. To avoid
> having to alter the named query down the road, I included all columns,
> but as I said, am only using 28 of them as dimension attributes.

> The question is, would it make any difference in performance if the
> named query only contained the columns I am actually using in the
> dimension?

> I am asking first because this is the particular dimension that took
> hours to process (but at least it did process after I changed it to
> process by table instead of attribute as you suggested), so if it
> won't make any difference, I won't bother trying it.

> Regards


.

Relevant Pages

  • Re: Maximum hard disk size
    ... the dimension 2100 does not natively support hard drives larger than 127gb. ... if incompatible with the system bios. ... use an external hard disk of any size you want. ...
    (alt.sys.pc-clone.dell)
  • Re: Important topics in math
    ... > Anyways, this summer I'm planning to read up on as much math as I can, ... gaze into dimension theory where you'll ... Or, to consider another matter, consider a closed disk with a line coming ... > it seems like a lot of probability could be covered by other courses, ...
    (sci.math)
  • Re: XP Pro to new machine
    ... recovery and made our own after tweaking the Dimension up. ... can't see why not including an XP Disk is such a big cost savings. ... No install CDs, no sale. ...
    (microsoft.public.windowsxp.general)
  • Re: Corrupt Registry?
    ... I tried the system restore and it didn't work - wouldn't work. ... Have you ever done a reinstall and been able to keep your programs? ... 2.Reinstall DELL Tools System Software disk ... 3.Drivers and Utilities--DELL Dimension tm Resource CD disk if you ...
    (microsoft.public.windowsxp.help_and_support)