SSAS 2005 hanging and users can't connect

I am running SQL2005 EE/Win2003 64bit. I have jobs that process data into the SSAS db/ cubes. Periodically the jobs just hang (without loading data) and I am unable to connect to SSAS using SS Mangement Studio & Profiler etc. I can find no errors or diagnostics or predict if/when it will happen again.

If I restart the SSAS service, everything works - till the next time.

Has anyone experienced / overcome a similar problem please ?

more ▼

asked Feb 03, 2012 at 11:54 AM in Default

avatar image

0 1 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Seems like the old problem of SQL Server 2005 SSAS with multi-processor machines. The default settings are fine for most SQL Server 2005 Analysis Services installations because the Memory Quota Manager will limit the number of parallel operations based on available memory. However, on high end servers with large amounts of RAM available the Memory Quota Manager is likely to allow a much higher number of parallel operations to occur, resulting in the number of process or query threads quickly exceeding the default thread pool sizes. The delay encountered for each thread created above the thread pool size can quickly accumulate and give the appearance that processing has slowed or completely stalled. Please follow this link to sort out if this is the problem.

more ▼

answered Feb 03, 2012 at 12:23 PM

avatar image

Usman Butt
14.6k 6 13 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 03, 2012 at 11:54 AM

Seen: 1450 times

Last Updated: Feb 03, 2012 at 12:25 PM

Copyright 2018 Redgate Software. Privacy Policy