Article ID: 815249 - View products that this article applies to.
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 may also notice the following error message in the Windows event log of the computer that is running SQL Server:
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
SuperSocket info: ConnectionListen(Shared-Memory (LPC)): Error 5.
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:
(http://support.microsoft.com/kb/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.
Note Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.
Date Time Version Size File name -------------------------------------------------------------- 19-Mar-2003 14:21 2000.80.791.0 29,244 Dbmslpcn.dll
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.
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:
824684For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the Standard Terminology That Is Used to Describe Microsoft Software Updates
(http://support.microsoft.com/kb/822642/ )How to configure the SQL Server Network Libraries by using SQL-DMO
Contact us for more help
Connect with Answer Desk for expert help.