Excessive Connection Pooling

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Excessive Connection Pooling

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Excessive Connection Pooling

Page: [1]

Message

<< Older Topic Newer Topic >>

Excessive Connection Pooling - 19 September 2007

Damien

Posts: 34
Score: 0
Joined: 18 August 2006
Status: offline

Hi All,
I am currently finished my development and the application is in UAT but i have had the dba's telling that Biztalk seems to be collecting connections excessively and not releasing them. I think this may be somthing to do with my connection pooling and my properties are as follows

Connection Properties
ConnectionLifetime = 0
DecrPoolSize = 1
IncrPoolSize = 5
MaxPoolSize = 100
MinPoolSize = 1
Pooling = True

Can anyone please advise if this is a correct assumption and at what sort of figures i should have these set to as a starting point.

Cheers D

Post #: 1

RE: Excessive Connection Pooling - 19 September 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Can you tell us what Provider you are using?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to Damien)

Post #: 2

RE: Excessive Connection Pooling - 20 September 2007

Damien

Posts: 34
Score: 0
Joined: 18 August 2006
Status: offline

Sorry should have mentioned that.

I am using ODP.NET 10.2.000 to poll an advanced queue on an oracle 10g instance.

Cheers

(in reply to Damien)

Post #: 3

RE: Excessive Connection Pooling - 25 September 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

You can try and reduce the max connections, this is currently set to 100. Does your receive shape fall into a short lived transaction in an orch?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to Damien)

Post #: 4

RE: Excessive Connection Pooling - 29 October 2007

Damien

Posts: 34
Score: 0
Joined: 18 August 2006
Status: offline

Pieter,
Sorry for the late reply.....

The receive falls into an orchestration with out any scope and the transaction is set to none (so i think this is a short lived transaction).

I also played with the connection pooling and when i reduce the connection pooling the problem occurs faster until the point where i decreased the connections to 1 and the problem would occur after a successful receive.

If i restart the biztalk host then this allows biztalk to operate again.

One other piece of information that may be helpful is that the Oracle database is off line once a night for maintance tasks and no action is taken with Biztalk for this period.

Cheers Damien

(in reply to Pieter)

Post #: 5

RE: Excessive Connection Pooling - 12 December 2007

Damien

Posts: 34
Score: 0
Joined: 18 August 2006
Status: offline

Hi Pieter this is still an issue for me can you advise?

(in reply to Damien)

Post #: 6