Question : I’ve got strange behavior on production. First user request thru application failed, I’ve got SQLServerException with “Lock request […]
Tag: connection-pooling
Verifying connection pooling server side with CONTEXT_INFO on
Question : I’m working with a 3 tiered application, Microsoft Dynamics AX, where the middle tier maintains connections to a […]
How to reset session context/variables in JDBC pooled connections – MySQL / Oracle
Question : In my application I have multithreads that needs to access database and I am using apache.tomcat.jdbc.pool.DataSource as a […]
Is it possible to configure pgbouncer to distribute queries among master and slave?
Question : We have master (write-read) and slave (readonly) Postgres 10 databases. Slave is online replication from master. Now our […]
Shared connection pool in SQL Server and prevention of cross-database queries
Question : Microsoft recommends that a shared connection pool should be used when running e.g. a SaaS software with one […]
What is the sense to use server_lifetime with PgBouncer?
Question : I’ve found server_lifetime option in PgBouncer config, and I’m trying to undestand if it is really needed in […]
Debug Connection Pool Error
Question : I have been getting the below error. System.Data.Entity.Core.EntityException: The underlying provider failed on Open. —> System.InvalidOperationException: Timeout expired. […]
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing
Question : We are using SQL Authentication (to reduce the number of connection pools) & .NET 4.0 connection strings to […]
MySQL stalls and strange threads/connections behavior is observed
Question : We have a MySQL instance which most of the time works just fine. From time to time, however, […]
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing
Question : We are using SQL Authentication (to reduce the number of connection pools) & .NET 4.0 connection strings to […]