Re: Very slow processing on SSAS2005 Std (Core Duo, MSSQL on same box, different disks for DB and AS)...

Thanks Jeje. Both servers (MSSQL / AS) are on the same box - whether my
router is coming into play or not is another matter.

Service account => blindingly fast. :)

"Jeje" <willgart@xxxxxxxxxxx> wrote in message
news:75EB1331-9224-4757-BE32-8C77BF290265@xxxxxxxxxxxxxxxx
I think you have some network issues like DNS bad configuration.
so authenticating the user is slow due to a slow name resolution.

verify that the station and the server DNS server is the DC IP address.
(the first DNS Server should be the DC server)

but you have a good solution by switching to the service account.


"Will Alber" <junk@xxxxxxxxxxxxxxx> wrote in message
news:O5FDgcexHHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
D'oh - that's the last time I provide credentials for impersonation.

Setting the impersonation to 'Use Service Account' sorted it, bizarrely.
I was using the credentials for my PC, apparently this lead to serious
performance issues, I expect that I was hitting a network timeout or
similar each time authentication was required. Processing dropped from
~2 mins to ~1 sec after using service account. :)

"Will Alber" <junk@xxxxxxxxxxxxxxx> wrote in message
news:eK2eCXexHHA.600@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,

I have a very simple cube (my bank account transactions), with around
500 fact table rows, a handful of very small dimensions, including a
date dimension built by SSAS.

When I process this cube, it takes 2 mins+, the majority of the time
being spent processing the dimensions.

I've profiled MSSQL (where the 'subject matter' DB is), and the sum
total of duration for queries used to build the cube amounts to around a
second.

I'm struggling to see why SSAS would be having a hard time building this
cube - any thoughts?

Many thanks,

Will Alber.





.

Relevant Pages