Database Server WMI Property Enumeration via T-SQL
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Collecting and analyzing performance data for database systems is hindered by the unavailability of certain data types, which are not readily collectible, and existing methods require setting up additional connections, making the process cumbersome and error-prone.
Innovation Solution
A method where a database server executes T-SQL statements to create and run an external script that collects performance data, enumerates WMI object properties, and loads this data into a table, allowing for retrieval through existing database connections without additional setup.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If additional connections are set up to collect performance data, then data collection capability is improved, but system complexity and error-proneness increase
Solution Approach 1:
The patent merges the performance data collection function with the existing database connection infrastructure. Instead of setting up separate connections for data collection, the system uses the existing database connection to execute T-SQL statements that trigger external scripts to collect WMI performance data. This combines multiple functions (data collection, script execution, data retrieval) through a single existing connection, reducing complexity while maintaining versatility.
Solution Approach 2:
The existing database connection is made multi-functional by enabling it to not only perform standard database operations but also to execute T-SQL statements that initiate external script execution for performance data collection. This universal approach allows the same connection to serve multiple purposes: data collection, data retrieval, and system control, eliminating the need for dedicated separate connections.
2Reliability
If external scripts are executed in separate processes, then database server stability is improved, but coordination complexity increases
Solution Approach 1:
The patent introduces an intermediary mechanism where the database server executes T-SQL statements that act as mediators between the database system and external scripts. The T-SQL statements trigger script execution and coordinate data flow between the separate process (external script) and the database server, managing the complexity of inter-process communication while maintaining server stability through controlled interaction points.
3Device complexity
If performance data collection is integrated through existing connections, then system complexity is reduced, but data availability may be limited
Solution Approach 1:
The patent segments the performance data collection process into distinct components: T-SQL statements for triggering, external scripts for actual data collection, and database tables for storage. This segmentation allows each component to specialize in its function while working together through the existing connection, ensuring comprehensive data availability without requiring complex integrated systems.
Data Source
AI summary
Methods and systems for collecting database performance data. During operation a database server can receive a set of T-SQL statements, wherein the database server executes on a computer system and provides access to a database. Next, the database server can execute the set of T-SQL statements, thereby causing the database server to: (1) create an external script which, when executed by the computer system, collects performance data in a file; (2) execute the external script on the computer system; (3) wait for the external script to complete execution; and (4) load the performance data from the file into a table in the database.