Enumerating WMI object properties through T-SQL
View Patent ↗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.
1. A method for collecting performance data for a database system, the method comprising:
a database server receiving a set of T-SQL (Transact-SQL) statements, wherein the database server executes on a computer system and provides access to a database; and
the database server executing the set of T-SQL statements, thereby causing the database server to:
create an external script which, when executed by the computer system, collects performance data in a file;
execute the external script on the computer system;
wait for the external script to complete execution; and
load the performance data from the file into a table in the database.
2. The method of claim 1 , wherein the external script, when executed by the computer system, enumerates WMI (Windows Management Instrumentation) object properties and writes the WMI object properties into the file.
3. The method of claim 2 , wherein each row of the table contains performance data for one WMI object property.
4. The method of claim 1 , further comprising:
the database server receiving a database query to retrieve performance data for a WMI object property; and
the database server performing the database query on the table to provide the performance data for the WMI object property.
5. The method of claim 1 , wherein the external script is executed in a process that is separate from the database server.
6. A non-transitory computer-readable storage medium storing a set of T-SQL (Transact-SQL) statements that, when executed by a database server executing on a computer system, cause the database server to perform a method for collecting performance data, the method comprising:
creating an external script which, when executed by the computer system, collects performance data in a file;
executing the external script on the computer system;
waiting for the external script to complete execution; and
loading the performance data from the file into a table in a database on the database server.
7. The non-transitory computer-readable storage medium of claim 6 , wherein the external script, when executed by the computer system, enumerates WMI (Windows Management Instrumentation) object properties and writes the WMI object properties into the file.
8. The non-transitory computer-readable storage medium of claim 7 , wherein each row of the table contains performance data for one WMI object property.
9. The non-transitory computer-readable storage medium of claim 6 , wherein the external script is executed in a process that is separate from the database server.
10. A database system, comprising:
a first computer system comprising a memory, a processor, and a set of instructions that, when executed on the processor, cause the processor to implement a client;
a second computer system comprising a second memory, a second processor, and a second set of instructions that, when executed on the second processor cause the second processor to implement a database server providing access to a database;
wherein the client is configured to send a set of T-SQL (Transact-SQL) statements to the database server; and
wherein the database server is configured to execute the set of T-SQL statements, thereby causing the database server to:
create an external script which, when executed by the second computer system, collects performance data in a file;
execute the external script on the second computer system;
wait for the external script to complete execution; and
load the performance data from the file into a table in the database.
11. The database system of claim 10 , wherein the external script, when executed by the second computer system, enumerates WMI (Windows Management Instrumentation) object properties and writes the WMI object properties into the file.
12. The database system of claim 11 , wherein each row of the table contains performance data for one WMI object property.
13. The database system of claim 10 ,
wherein the database server is configured to receive a database query to retrieve performance data for a WMI object property; and
wherein the database server is configured to perform the database query on the table to provide the performance data for the WMI object property.
14. The database system of claim 10 , wherein the external script is executed in a process that is separate from the database server.