INF: SQL Server Client Memory Required for Open Connection

Last reviewed: April 25, 1997
Article 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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.