INF: SQL Server Client Memory Required for Open Connection

ID: Q70672

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

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.

Additional query words: dblib Windows NT


Keywords          : kbprg SSrvDB_Lib SSrvProg SSrvWinNT 
Version           : 4.2 | 4.2   | 4.2
Platform          : MS-DOS OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 11, 1999