Troubleshooting and Monitoring Pooling issues

Resources available – Performance Monitor (Perfmon) – Database-specific resources can be used SQL Profiler Oracle Instance Manager SQL Profiler – Inspect Connect, Disconnect, Existing Connection Events – sp_who T-SQL instruction will display the number of active connections along with supplemental info.

ODBC Connection Pooling

The operation of establishing a connection to a database can be expensive. In applications that repeatedly open connections with similar parameters, this cost can affect overall application performance. To address this problem, ODBC provides what is known as “Connection Pooling”. In connection pooling, connections that are closed by the application are not actually closed, but…

How to Enable ODBC Connection Pooling Performance Counters

ODBC Connection Pooling enhances the performance of database connections. By default, the performance counters for Connection Pooling are disabled. How to enable PERFMON counters: To enable the performance counters, follow these steps: 1. Open Control Panel. 2. Double-click the ODBC icon. 3. Click the Connection Pooling tab. 4. In the PerfMon section, select Enable. 5….


ODBC Tracing

Another tool frequently used for troubleshooting ODBC problems is ODBC Tracing. ODBC Tracing is a service provided by the driver manager and records every ODBC call made into a text file. ODBC Tracing can be turned on through the ODBC Data Source Administrator, in the “Tracing” tab. To trace an application, make sure the application…


ODBC Programming Overview and Architecture

ODBC ODBC (Open Database Connectivity) is an older technology designed to allow developers to create a common codebase which provides access to a variety of relational data stores. Its methods are exposed in a traditional, non- object – oriented, C language API. Visual Basic programmers can also call ODBC functions by declaring them in their…