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

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

  • Re: Very slow processing on SSAS2005 Std (Core Duo, MSSQL on same box, different disks for DB and AS
    ... 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. ... but you have a good solution by switching to the service account. ... I have a very simple cube, ...
    (microsoft.public.sqlserver.olap)
  • Re: Replication issues
    ... I wanted to say Zone Transfers not Zone Forwarding. ... AD-Integrated DNS does not do zone transfers between the ... your DNS server will bypass ...
    (microsoft.public.windows.server.active_directory)
  • Re: Servers hang on boot
    ... The last DC at that site (not a DNS server). ... EventID: 0x00000457 ... (Event String could not be retrieved) ...
    (microsoft.public.windows.server.networking)
  • Re: DNS Redesign Issue
    ... set the new child domain DNS server as primary for the domain controllers? ... -If you are going to create a new AD Integrated Zone in each child domain, ...
    (microsoft.public.windows.server.dns)
  • Re: Internet connection wizard
    ... turn on DHCP on the workstation. ... Connection-specific DNS Suffix. ... calling CNetCommit::ValidateRouterConnectionProperties. ... Call to Reading preferred DNS server IP returned ok. ...
    (microsoft.public.windows.server.sbs)