on 05-22-2016 9:07 AM
Hello, all
I have a completely unclear picture regarding connection polling in our .NET service, which connects to SQL anywhere 16 through OdbcConnection class (c#).
First of all, the service is getting a lot of Failed to connect to DB errors and I believe that one of the issues here is that it is not using a connection pool of the ODBC driver.
Main question: how to recognize a polled connection from Sybase central connection tab (or from a sa_conn_info() view, I am not picky on the tool)?
My second question: Can ODBC driver pool connections which connect to the same DB, but do not have identical connection strings. This particular service assigns CON and THREAD values to the connection string before calling CreateConnection() function, so almost all connection string are different.
My third question: Is connection id of the db connection changes after being reused by connection poll cache? So, if the client queries the polled connection info, will it see the same connection id on multiple occurrences?
Thank you
Arcady Abramov
Hi Arcady,
You can see the condition of the connection pooling from the database properties.
(ConnPoolCachedCount, ConnPoolHits, ConnPoolMisses)
For details, please see below.
"Database Properties window: Extended Information tab"
http://dcx.sap.com/index.html#sa160/en/sacshelp/database-prop-extended.html
Connection pooling needs the same connection parameter.
Accordingly, I think that your service doesn't use the connection pooling.
I believe that the connection id doesn't change while the connection is pooling.
Connection pooling of SA16 has some issues.
I will recommend that apply the latest EBF.
Regards,
Koichi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Koichi
I used the screen and I can, actually, see connection cache hits count quite high.
But I also see connections appear and disappear in the connection screen.
So, (and this is very important for me), I need to have answers to question 1. I need to be able to recognize pooled connections from non-pooled connection using some database tool (any tool would do, I am not picky).
Thank you
Arcady
Hi Arcady,
Unfortunately, I don't know how to see the status of the connection pool in those tools.
I will use the diagnosis communication message of the database server instead.
You can see the log of the connection pool with -z and -o database server option.
"-z database server option"
http://dcx.sap.com/index.html#sa160/en/dbadmin/z-database-dbengine.html
"-o database server option"
http://dcx.sap.com/index.html#sa160/en/dbadmin/o-database-dbengine.html
Regards,
Koichi
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.