Access Database with Multiple Users Slow on Terminal Server (231798)
The information in this article applies to:
- Microsoft Windows NT Server 4.0 Terminal Server Edition SP4
- Microsoft Windows NT Server 4.0 SP4
- Microsoft Windows NT Server 4.0
- Microsoft Windows NT Server 4.0 SP1
- Microsoft Windows NT Server 4.0 SP2
- Microsoft Windows NT Server 4.0 SP3
This article was previously published under Q231798 SYMPTOMS
When multiple users on a computer running Windows NT Server 4.0, Terminal Server Edition attempt to open the same Microsoft Access database on another computer running Windows NT Server, performance may be severely degraded. However, single Terminal Server users do not experience any performance degradation.
If several Terminal Server users communicate with different servers containing Access databases, performance is not impaired, but when they open the same database, query timing may be an order of magnitude slower.
CAUSE
This behavior occurs because database record locking is affecting performance. By default, Terminal Server establishes a single session with the Windows NT Server-based computer that contains the database. Multiple users querying the database through that one session can cause conflicts. When you use Network Monitor to track network traffic, the trace shows that the computer is no longer using opportunistic locking.
RESOLUTION
To resolve this issue, apply the fix described in the following Microsoft Knowledge Base article:
190162 Terminal Server and the 2048 Open File Limitation
This article describes how to set up different sessions between the servers, and describes changes to Terminal Server that are made with Service Pack 4. After you apply the fix and restart the computer, the performance issue should be resolved.
In addition, if there are multiple users on the computer doing large amounts of record locking, refer to the following article in the Microsoft Knowledge Base:
191370 Slow Network Performance with Terminal Server
| Modification Type: | Major | Last Reviewed: | 2/24/2004 |
|---|
| Keywords: | kbinterop kbnetwork kbprb KB231798 |
|---|
|