Enumerating WMI object properties through T-SQL

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.