INF: Different Kinds of Analysis Services Timeouts (304213)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
  • Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q304213

SUMMARY

There are several kinds of timeout objects in the Decision Support Object (DSO) object model. This article outlines the difference between the different timeout objects.

MORE INFORMATION

Timeout Objects In Analysis Services 2000
  • DSO Server.ConnectTimeout is the timeout for DSO to connect to the server.
  • DSO Server.Timeout is the timeout for DSO to communicate with the server once connected.

    NOTE: There is no way to set the connect timeout for Analysis Services and DSO to connect to the data source such as Microsoft SQL Server and Oracle. DSO always uses 15 seconds and Analysis Services uses the default.
  • The registry entry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion\MaxOLEDBTimeout is the timeout for the server and DSO to communicate with the data source.
  • DSO also has a LockTimeout property that is not used at this time.
In the Server Properties dialog box in Analysis Manager, under the Processing tab, you can set a Server Timeout property that in turn sets both DSO Server.Timeout and HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion\MaxOLEDBTimeout to the same value. It does not make sense for the two timeouts to be different because the smaller timeout fails the operation anyway.

Timeout Objects In OLAP Services 7.0

  • The HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Server Connection Info\ServerConnectTimeout registry entry (if specified) is the timeout for DSO to connect to the server.
  • DSO Server.Timeout is the timeout for DSO to communicate with the server once connected.

    NOTE: There is no way to set the connect timeout for the server and DSO to connect to the data source such as Microsoft SQL Server and Oracle. DSO always uses 15 seconds and Analysis Service uses the default.
  • The registry entry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion\MaxOLEDBTimeout is the timeout for the server to communicate with the data source (executing SQL statements). DSO does not use any timeout that implies provider default.
There is no exposed dialog box in OLAP Manager to change the server timeout value in OLAP 7.0. The only way to set the DSO Server.Timeout property is to write DSO code. Here is a Visual Basic code sample to set the DSO Server.Timeout property: 
Dim dsoServer As new DSO.Server

' put the name of your server
dsoServer.Connect "server_name"

' default is 3600, it is in seconds - 1hour, change it to 10000 seconds, for example.
dsoServer.Timeout = 10000

dsoServer.Update
dsoServer.CloseServer
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbinfo KB304213
©2004 Microsoft Corporation. All rights reserved.