FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server
This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft distributes SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.
When a client program runs a query against a Microsoft SQL Server Service Pack 3 (SP3) database, the query may take longer than usual. You may notice this behavior when you do the following:
- You run a query on the SQL Server database by using SQL Query Analyzer while the client program is connected to the database.
- You restart the instance of SQL Server while SQL Query Analyzer is still open.
2003-02-19 19:26:10.12 server SQL server listening on TCP, Named Pipes.The earlier message indicates that SQL Server is not using the shared memory network library.
You may also notice the following error message in the Windows event log of the computer that is running SQL Server:
SuperSocket info: ConnectionListen(Shared-Memory (LPC)): Error 5.Note When you close SQL Query Analyzer, you may notice that the response time of the query run from the client program returns to normal
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Hotfix informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name -------------------------------------------------------------- 19-Mar-2003 14:21 2000.80.791.0 29,244 Dbmslpcn.dllNote Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.
To work around this problem, turn off the shared memory protocol on the computer that is running SQL Server Service Pack 3 (SP3). To do this, follow these steps.
Note Turning off shared memory protocol may cause performance degradation of the computer that is running SQL Server.
- Click Start, point to Programs, point to Microsoft SQL Server, and then click Client Network Utility.
- In the SQL Server Client Network Utility dialog box, click the General tab.
- Click to clear the Enable shared memory protocol check box, and then click OK.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
The problem may affect the performance of applications including the services and Web applications that run on the computer that is running SQL Server SP3. However, working around this problem by turning off shared memory protocol can cause performance degradation on the computer. This behavior occurs because the shared memory network library uses a location in the computer's memory that does not require network or disk access. When you use a network-based protocol such as TCP/IP, the computer uses more memory.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the Standard Terminology That Is Used to Describe Microsoft Software UpdatesFor additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
822642 How to configure the SQL Server Network Libraries by using SQL-DMO
Article ID: 815249 - Last Review: 12/08/2015 02:08:01 - Revision: 2.1
Microsoft SQL Server 2000 Service Pack 3
- kbnosurvey kbarchive kbbug kbfix kbqfe kbsqlserv2000presp4fix kbeventlog kbclient kbquery kbconnectivity kbhotfixserver KB815249