For a SQL Server DB-Library (DB-Lib) application, a certain amount of
memory is required on the client for each open user connection.
NOTE: A user connection is established using the dbopen() function.
When row buffering is not used, each connection requires the
following: 300 bytes for the DBPROCESS data structure, a 1024-byte
read/write buffer, and temporary storage for items such as command
buffers and binding information. This adds up to approximately 2K per
open connection. In addition, data structures, row data, and so forth,
are stored internally, with memory use dependent on the actual
returned results.
If row buffering is used for a particular connection, the memory
required for that connection will increase according to the size of
the buffer and the length of each row.
SQL Server uses 44K for each user connection. For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
160234 Memory Overhead for Connections, Objects, Locks, and DBs in SQL Server 6.x