Knowledge Base >> Critical Resource Data Collection issue on SQL Server 2000/2005

Critical Resource Data Collection issue on SQL Server 2000/2005 - Confio Article 1566

Confio Article: 1566 Published: Oct 08 2009 9:27 AM
Version: 8.0.27 only Topic(s): Database Problems
Product(s): Ignite
Database(s): MS SQL

Critical Resource Data Collection issue on SQL Server 2000/2005


Some versions of SQL Server 2000 and 2005 have bugs that cause memory leaks that can, over time, cause SQL Server to run too low on memory and eventually crash.  The Ignite PI 8.0.27 Beta release collects data on some system resources by calling stored procedures (that have the aforementioned bugs) on the SQL Server monitored instance.

This is documented by Microsoft in the following KB article: http://support.microsoft.com/kb/937277/    

Note: The Repository database is not affected by this issue -- only monitored SQL Server instances potentially have this issue.

 

Affected Versions


Ignite PI 8.0.27 installs that are monitoring SQL Server instances with the versions below those listed here:

  • Below 8.00.2039 = SQL Server 2000 SP4
  • Below 9.00.3175 = SQL Server 2005 SP2 + Cumulative Update 2


To check the version of a SQL Server monitored instance, either:

    1. Look at the Version column on the Ignite PI Home page, or
    2. Run the following command on SQL Server:
SELECT @@VERSION

 

Solution

 

Upgrade Ignite PI to version 8.0.31 or higher 

 

 

 

Tags: bug memory sql server leak