Extended T-SQL Collector

Custom collector types to extend and simplify the features offered by the built-in SQL Server Data Collector and read data from Extended Events and/or queries.

Extended T-SQL Collector = Extended Events + Data Collector

Extended T-SQL Collector includes a XEReader collector type that lets you collect data from Extended Events sessions. This is the easiest way around to save Extended Events to a table.

SQL Server ships with a built-in T-SQL Collector Type that lets you collect data based on an custom T-SQL statement. However, it doesn't let you collect data in any fomat: you are limited to the data types accepted by the intermediate format used to store the cache files (SSIS Raw Files, which do not allow BLOB data).

To overcome this limitation, Extended T-SQL Collector offers a T-SQL query collector type that uses a different cache format and lets you collect XML and varchar(max)/nvarchar(max) columns.

When it comes to performance tuning and troubleshooting, the most interesting data is available in SQL Server as XML. With this collector type, you can easily collect and upload XML data to your MDW instance.

The Collection Set Manager utility lets you manage:
Here are some screenshots of the GUI:

Connection:
Connect.png

Collector Type Editor:
CollectorTypeEditor.png

Collection Set Editor:
CollectionSetEditor.png

Collection Item Editor:
CollectionItemEditor.png

TSQL Parameters Editor:
ParametersEditor.png

XEReader Parameters Editor:
XEReaderParametersEditor_1.png
XEReaderParametersEditor_2.png

SQL Editor:
SQLEditor.png

XML Editor for Collector Type Parameter Schema and Formatter and for Collection Items parameters:
XMLEditor.png

Browse the collected data:
XEDataForm.png

Collection sets and collection items can also be created via script. You can find examples in the documentation.

Features

Requirements