Kbase P23829: SQL Server SP3: Noticeable performance degradation when executing queries that return a large number
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
MS SQL 2000
MS SQL DataServer
Windows 2000
SYMPTOM(s):
Performance degradation when running program
Taking a long time to create rows within SQL Server
The issue is noticeable when executing queries that return a large number of columns in the result set
The issue is noticeable when repeatedly execute prepared queries that have large numbers of columns.
Same code has no problems running against ORACLE
-Dsrv BINDING,0 does not help
Performance degradation is not seen against SQL Server 2000 with no SP
Performance degradation is not seen against SQL Server 2000 with SP1
Performance degradation is not seen against SQL Server 2000 with SP2
SQL Server 2000 SP3
Using ODBC driver 2000.80.528.00 dated 9/24/2001
CAUSE:
The issue is specific to Microsoft SQL Server 2000 (all editions) SP3. Please refer to; http://support.microsoft.com/default.aspx?scid=kb;EN-US;814410
814410 FIX - Performance Degradation and Memory Leak in the SQL Server ODBC Driver: The Microsoft ODBC Driver for SQL Server that is installed by SQL Server 2000 SP3 changes how SQL Server allocates column metadata for ODBC statements. In certain cases, the driver can cause a memory leak.
FIX:
Apply SQL Server 2000 Service Pack 3a. This will install the drvier 2000.81.9031.38 dated Mar 11, 2003
A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that are experiencing this specific problem.
To resolve this problem, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
The English version of this fix has the file attributes (or later) 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
--------------------------------------------------------------
10-Feb-2003 21:41 2000.81.9031.29 24,576 Odbcbcp.dll
10-Feb-2003 21:40 2000.81.9031.29 385,024 Sqlsrv32.dll