data-collector-functions-transact-sql.md

title	Data Collector Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	data collector [SQL Server], functions
ms.assetid	8efe8bb4-face-4608-83f4-cc7c6e9faf31
caps.latest.revision	11
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

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)