November 13, 2006, 10:31 AM
Aaron M. ReiffMSSQL Connections
Good day! Want to understand how WF 5.2x and higher manages connections to the database server. In this case we're using WF 5.23 connecting to MS SQL Server - eventually upgrading to 7.14. It appears that some of the connections are hanging and I want to see how that's being controlled. Can anyone point me in the direction of this info?
November 14, 2006, 09:57 AM
KerryHi Aaron,
Release 5.2 of the Data Adapter for Microsoft SQL Server is based on OLE DB, the Microsoft-recommended API for developing high-performance components. The adapter uses the OLE DB Provider for SQL Server (SQLOLEDB), a native, high-performance provider that directly accesses the SQL Server TDS protocol.
Can you please a little more information on the following questions:
What do you mean by "hanging"?
Is data returned and then there is no activity?
A request is made and no data returns?
Agents are available but no one can connect?
Data is returned but then the connection to the database is not freed? Does the client disconnect?
Hope this helps.
Cheers,
Kerry
November 14, 2006, 10:57 AM
Aaron M. ReiffKerry
Thanks for responding. My answers are below.
Aaron
What do you mean by "hanging"? - Example: A session started this morning at 9.20am. An hour and half later the session still appears. The last command executed is 'TABLE FI' (which I assumed means that it's trying open a table file)
Is data returned and then there is no activity? - No Activity
A request is made and no data returns? - Yes
Agents are available but no one can connect? - Agents are available until we max out because many are hanging. When there are no agents left . . .
Data is returned but then the connection to the database is not freed? Does the client disconnect? - This is the reason for my question. How does WF free the connection?
November 15, 2006, 09:51 AM
KerryHi Aaron,
If the request is made and neither data or an error message is returned then the request may still be processing.
Are the databases large? Is a key field being used?
Does the problem happen for every request?
The connection should not disconnect until after the data is returned.
At this point, we strongly suggest you to contact Information Builders' Customer Support Services and open a case for further assistance, as we may need to know details of your current system/environment. You may either call at 1-800-736-6130, or access the online system
InfoResponse. Here is a list of information to be ready when you call:
http://techsupport.ibi.com/before_you_call.jsp.
Hope this helps.
Cheers,
Kerry