2008

TKU Sep 2008

In TKU September we enhanced the Microsoft SQL Server pattern so it would recognise additional build numbers of the product.

TKU Nov 2008

New Versioning capabilities added in TKU November - versioning now performed by WMI Query in preference to Registry Query, since if it succeeds the full_version will reflect all hotfixes applied

TKU Dec 2008

In TKU December update, the pattern attempts to obtain listening port information.
In addition to this, the pattern attempts to obtain the list of databases managed by the SQL Server instance
The code that determines whether an instance-based or group-based SI will be created has been improved to create instance-based SIs more often

2009

TKU Dec 2009

In TKU December update, we made changes to the pattern to ensure Additional Attributes were only displayed in the UI when their contents was populated.

2010

TKU Jan 2010

In TKU January we revised the versioning mechanism, particularly pertaining to the WMI Query method. Trailing zeros are now removed from the bottom of the extracted version, and the mapping table was subsequently simplified to accomodate this change.

TKU June 2010

In TKU June 2010 an inconsistency where the port attribute could be set as either integer or string (depending on how the data was obtained) was removed. The port attribute is always set to string. Finally, additional SQL Server versions were added to product version mapping table.

TKU July 2010

In TKU July 2010 extra registry keys were added to check for version

TKU September 2010

In TKU September 2010 a change was made to ensure the pattern does not check for registry keys that clearly do not exist

TKU October 2010

In TKU October 2010 a number of additional registry keys were added to support the acquisition of edition and backup directory information for Microsoft SQL Server 2008 R2.

2011

TKU January 2011

In TKU January 2011 a number of changes were made on the pattern:

• Further improved obtaining information from the MS SQL Server 2008 R2
• Updated the mechanism used to map the full version to product version. The mapping is now done more generically which will lead to less frequent need to update version mapping tables.
• The pattern now tries to determine if the DB server is listening on a specific IP address and stores this information as a 'bind_address' SI attribute.
  • This information can be used by Deep DB discovery patterns shipping with ADDM 8.2 to query the database server using a specific IP address

TKU March 2011

In TKU March 2011 the pattern has been further enhanced to determine whether the discovered SQL Server is within an SQL Server cluster, and if so to attempt to determine the cluster IP address the SQL server is listening on. If the information is obtained, it can be used by Deep DB discovery patterns shipping with ADDM 8.2 to query the database server using a specific IP address

TKU May 2011

In TKU May 2011 the SQL Server pattern has been further enhanced with an additional approach to determining the cluster IP address for SQL Server instances that are part of an SQL Server.
Furthermore, the SQL Server Database Detail pattern was updated to optionally obtain database sizes (in KB) and store them as an attribute of DatabaseDetail nodes, as well as to optionally execute the 'sp_databases' query as the primary query to obtain the list of databases

TKU October 2011

In TKU October 2011 all the creation code for DatabaseDetail nodes was moved to the extended pattern. Should the extended pattern be unable to get a list of databases from a JDBC database query, it will attempt to get such a list from a directory listing or command. In addition, the path to the data directory is now alternatively obtained from registry.

TKU November 2011

In TKU November 2011 an explicit database query to get the list of databases was added to support Microsoft SQL Server 2000. In addition, the list of databases can now also be obtained via a WMI Query. The file-based method of getting the list of databases was moved to become the last of the four methods. The pattern now handles the storing of multiple listening ports by the addition of a new attribute, port_list, on the Software Instance.

2012

TKU January 2012

In TKU January 2012 the extended database details pattern was modified to handle correctly database filenames that contain a space.

TKU February 2012

In [TKU February 2012] for SQL Server 2000, added support for obtaining listening IP address when it is part of a cluster.