Microsoft KB Archive/70672

= INF: SQL Server Client Memory Required for Open Connection =

Article ID: 70672

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q70672



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

Additional query words: dblib Windows NT

Keywords: kbprogramming KB70672

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.