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

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: Service Account replaced by IUSR ??
    ... That should be the only reason why that user would get used at all. ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ... in order to avoid impersonation I did the following: ... - create a service account, register it in AD using the setspn.exe tool ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Very slow processing on SSAS2005 Std (Core Duo, MSSQL on same box, different disks for DB and AS
    ... in fact you have found a possible issue on your server. ... the service account is local on the server and don't required any network ... so authenticating the user is slow due to a slow name resolution. ... I have a very simple cube, ...
    (microsoft.public.sqlserver.olap)
  • 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: Cached Credentials?
    ... Web Site http://bobfox.net ... Blog Site http://sharepointblogs.com/bobfox ... Service Account as my credentials in IE. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Azman: AzAuthorizationStoreClass.Initialize
    ... ADAM on the WinServer 2003 box. ... I had a service account created and we are doing an impersonation. ... in ADAM and thru azman. ...
    (microsoft.public.windows.server.active_directory)