data-collector-functions-transact-sql.md

title	Data Collector Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	data collector [SQL Server], functions
ms.assetid	8efe8bb4-face-4608-83f4-cc7c6e9faf31
author	rothja
ms.author	jroth

Data Collector Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

The data collector uses several functions to obtain information about data collection and data collector statistics, or to obtain data.

The following table lists the functions that the data collector uses.

fn_syscollector_get_execution_details (Transact-SQL)	fn_syscollector_get_execution_stats (Transact-SQL)
snapshots.fn_trace_getdata (Transact-SQL)

See Also

Data Collection
Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Management Data Warehouse Stored Procedures (Transact-SQL)