dbTalk Databases Forums  

Queries against Analysis Services "timing out"

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Queries against Analysis Services "timing out" in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jesse O
 
Posts: n/a

Default Queries against Analysis Services "timing out" - 10-25-2005 , 02:39 PM






Several times a day, MSAS quits on us - it'll become unresponsive (queries
against it time out) for a few minutes and then all of a sudden come back.
It will happen when there are no cubes or dimensions processing.

Any idea what I should be looking for or how to trouble shoot this? It's my
first venture into MSAS performance tuning so any advice would be very much
appreciated.

Thanks in advance guys!



Reply With Quote
  #2  
Old   
Denny Lee
 
Posts: n/a

Default Re: Queries against Analysis Services "timing out" - 10-26-2005 , 11:35 AM






Are there any errors that are propped up into the event log that correspond
to the unresponsiveness times?

A great Analysis Services Performance Guide can be found at:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Quote:
Several times a day, MSAS quits on us - it'll become unresponsive (queries
against it time out) for a few minutes and then all of a sudden come back.
It will happen when there are no cubes or dimensions processing.

Any idea what I should be looking for or how to trouble shoot this? It's
my first venture into MSAS performance tuning so any advice would be very
much appreciated.

Thanks in advance guys!





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.