dbTalk Databases Forums  

Timeouts

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


Discuss Timeouts in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Magoun
 
Posts: n/a

Default Timeouts - 12-02-2005 , 08:49 AM






Greetings,

I am trying to tune my application and the first step is to test certain
long-running queries to see if certain variations in the MDX will allow them
to run faster. The problem is that I keep getting timeouts on my test server
after ~1000 seconds or so. I have altered the timeout properties in the
following locations:

On the XMLA server:
Analysis Server timeout property = 24000 seconds
IIS timeout property for the website = 24000 seconds
httpExecution timeout in machine.config = 24000 seconds
datasources.xmla timeouts (both named and unnamed) = 24000 seconds

On the Web Server (at this time it is my desktop -- I am running the code in
the debugger):
httpExecution timeout in machine.config = 24000 seconds
IIS timeout property for the website = 24000 seconds

I am missing something. Can someone help me?

Thanks,
Chris Magoun



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.