Microsoft SQL Server - Database Detail Pattern - Change History

2011

TKU May 2011

The following improvements were made:

• Updated the pattern to optionally obtain database sizes (in KB) and store them as an attribute of DatabaseDetail nodes.
• Updated the pattern to optionally execute the sp_databases query as the primary query to obtain the list of databases.

2012

TKU January 2012

Updated the pattern to handle database filenames that contain a space.

TKU September 2012

The following improvements were made:

• Resolved an issue with obtaining a list of databases through SQL query when discovering SQL Servers with case-sensitive settings.
• Reduced the number of individual messages related to TableDetail node creation written to the log file.

2014

TKU February 2014

Removed the underscore from the server name in WMI query calls.

TKU March 2014

Removed the dollar characters from the server name in WMI query calls.

2017

TKU February 2017

Added details of Availability Groups.

TKU April 2017

The following improvements were made:

• Improved the database query used to obtain information about Availability Groups.
• Improved the method used to obtain database information through file-based discovery.
• All DatabaseDetail nodes have the same key regardless of provenance.

TKU May 2017

Updated the pattern to always use additional methods to find databases even if the main method (database queries) succeeds.

TKU October 2017

The following improvements were made:

• Added support for discovering databases by parsing the ERRORLOG file (if the relevant configuration option is enabled).
• Updated the pattern to discover the compatibility level for databases.

TKU November 2017

The following improvements were made:

• Improved the discovery of databases through directory listing.
• Updated the database queries to properly retrieve the physical name. If you continue experiencing difficulties getting the database size, enable the get_db_individ configuration option (this might increase the discovery time).

2018

TKU January 2018

Added validity checking for databases and the following improvements to Availability Groups:

• Linked databases in the Availability Group to related ClusterService only (DRDC1-10025).
• Updated code for SQL queries to prevent integration errors.
• Enhanced the approach for searching replica databases.
• Added the always_on_availability_group and always_on_availability_group_role attributes for the database.
• Removed the group_id attribute due to its internal purposes only.

TKU February 2018

The following improvements were made:

• Updated parsing of the ERRORLOG files containing non-UTF-8 characters.
• Updated the search of the data directory for database details to search all subdirectories of the database directory.

Note: These updates work only if the relevant configuration option is enabled.

TKU March 2018

Improved the substitutions used to ensure that WMI queries work successfully.

TKU April 2018

Updated the validity check to enable database names with hyphens.

TKU July 2018

Removed validity checking by introducing enhanced methods of parsing osql.exe.

TKU August 2018

Improved how the osql command handles long database names.

TKU September 2018

Updated the SQL queries used to obtain information about Database nodes: name, compatibility, size, and physical name.

2019

TKU May 2019

Minor bug fix.

TKU September 2019

Resolved an issue with parsing the output of osql.exe.

2020

TKU March 2020

Resolved an issue in the query used for SQL Server 2000 to get a list of managed databases.

TKU October 2020

Added the Availability Group listener_ip attribute to the related ClusterService node (DRDC1-15418).

2021

TKU March 2021 and TKU April 2021

Added details of OLE linking and resolved several issues.

TKU August 2021

Updated the pattern to obtain a list of databases by using the sqlcmd command (DRDC1-16998).

TKU November 2021

Added details of the database state to the Database nodes.

2022

TKU February 2022

Ceased to return the osql command if the relevant configuration option is disabled.

TKU May 2022

Added extra error checking when retrieving database details through WMI query calls.

TKU June 2022

Replaced the legacy method of database querying by the standard discovery.sqlQuery command.

TKU September 2022

Moved to a standard function to call the SELECT TABLE_NAME, TABLE_SCHEMA query used to find table information.

TKU October 2022

Added extra error checking.

2024

TKU March 2024

The following improvements were made:

• Improved the method to find the database size when the pattern cannot run the sp_databases and sp_helpdb stored procedures (DRDC1-21556).
• Enhanced the code to keep DBs when the command fails (DRDC1-22778).

2025

TKU February 2025

The pattern now reports the size of the database tables.  It also now reports the both the listening IP and port information for the Availability Group