x

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

IanSinclair gravatar image

IanSinclair
0 1 1 2

(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

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1945
x171

asked: Feb 03, 2012 at 11:54 AM

Seen: 1127 times

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