Microsoft KB Archive/320719

= FIX: Analysis Services Client Application Memory Usage Grows Each Time You Run a Query =

Article ID: 320719

Article Last Modified on 2/21/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q320719



BUG #: 12783 (plato7x)



SYMPTOMS
When you run a Multidimensional Expressions (MDX) query that uses the Descendants function to retrieve members of a parent-child dimension with the Non-Leaf data visible property set to true, the working set for the client application that is issuing the query continues to grow each time the query runs. This problem occurs even if you run the same query multiple times.



RESOLUTION
To 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 INF: How To Obtain the Latest SQL Server 2000 Service Pack

NOTE: The following hotfix was created before the release of Microsoft SQL Server 2000 Service Pack 3.

The English version of this fix should have the following file attributes or later:  Date        Time       Version        Size       File name -

19-MAR-2002 13:57 PM       8.0.0.601  4,043,328  Msmddo80.dll 19-MAR-2002 13:56 PM       8.0.601.0  1,008,192  Msmdgd80.dll 19-MAR-2002 12:53 PM       8.0.601.0  1,774,148  Msmdsrv.exe 19-MAR-2002 13:57 PM       8.0.601.0  2,024,016  Msolap80.dll 18-APR-2001 12:23 AM   2000.80.382.0    815,676  Sqldata.dll 19-MAR-2002 13:56 PM   2000.80.534.0    590,396  Sqlsort.dll NOTE: Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 Analysis Services.

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.

Additional query words: memory leak OLAP Descendants QFE HOTFIX

Keywords: kbbug kbfix kbsqlserv2000presp3fix kbsqlserv2000sp3fix KB320719

-

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

© Microsoft Corporation. All rights reserved.