Data Collector Functions (Transact-SQL)

MSDN Home

MSDN
MSDN Library
Servers and Enterprise Develop…
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Transact-SQL Reference

Data Collector Functions (Transact-SQL)

fn_syscollector_get_execution_…
fn_syscollector_get_execution_…
snapshots.fn_trace_gettable (T…

Transact-SQL Reference

Transact-SQL Syntax Convention…
Tutorial: Writing Transact-SQL…
+ (Add) (Transact-SQL)
+ (Unary Plus) (Transact-SQL)
+ (String Concatenation) (Tran…
+= (Add EQUALS) (Transact-SQL)
+= (String Concatenation) (Tra…
- (Negative) (Transact-SQL)
- (Subtract) (Transact-SQL)
-= (Subtract EQUALS) (Transact…
* (Multiply) (Transact-SQL)
*= (Multiply EQUALS) (Transact…
/ (Divide) (Transact-SQL)
/= (Divide EQUALS) (Transact-S…
\ (Backslash) (Transact-SQL)
% (Modulo) (Transact-SQL)
%= (Modulo EQUALS) (Transact-S…
% (Wildcard - Character(s) to …
& (Bitwise AND) (Transact-SQL)
&= (Bitwise AND EQUALS) (Trans…
| (Bitwise OR) (Transact-SQL)
|= (Bitwise OR EQUALS) (Transa…
^ (Bitwise Exclusive OR) (Tran…
^= (Bitwise Exclusive OR EQUAL…
~ (Bitwise NOT) (Transact-SQL)
= (Equals) (Transact-SQL)
> (Greater Than) (Transact-SQL…
< (Less Than) (Transact-SQL)
>= (Greater Than or Equal To) …
<= (Less Than or Equal To) (Tr…
<> (Not Equal To) (Transact-SQ…
!< (Not Less Than) (Transact-S…
!= (Not Equal To) (Transact-SQ…
!> (Not Greater Than) (Transac…
-- (Comment) (Transact-SQL)
/*...*/ (Comment) (Transact-SQ…
[ ] (Wildcard - Character(s) t…
[^] (Wildcard - Character(s) N…
_ (Wildcard - Match One Charac…
$PARTITION (Transact-SQL)
@@CONNECTIONS (Transact-SQL)
@@CPU_BUSY (Transact-SQL)
@@CURSOR_ROWS (Transact-SQL)
@@DATEFIRST (Transact-SQL)
@@DBTS (Transact-SQL)
@@ERROR (Transact-SQL)
@@FETCH_STATUS (Transact-SQL)
@@IDENTITY (Transact-SQL)
@@IDLE (Transact-SQL)
@@IO_BUSY (Transact-SQL)
@@LANGID (Transact-SQL)
@@LANGUAGE (Transact-SQL)
@@LOCK_TIMEOUT (Transact-SQL)
@@MAX_CONNECTIONS (Transact-SQ…
@@MAX_PRECISION (Transact-SQL)
@@NESTLEVEL (Transact-SQL)
@@OPTIONS (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
@@PACKET_ERRORS (Transact-SQL)
@@PROCID (Transact-SQL)
@@REMSERVER (Transact-SQL)
@@ROWCOUNT (Transact-SQL)
@@SERVERNAME (Transact-SQL)
@@SERVICENAME (Transact-SQL)
@@SPID (Transact-SQL)
@@TEXTSIZE (Transact-SQL)
@@TIMETICKS (Transact-SQL)
@@TOTAL_ERRORS (Transact-SQL)
@@TOTAL_READ (Transact-SQL)
@@TOTAL_WRITE (Transact-SQL)
@@TRANCOUNT (Transact-SQL)
@@VERSION (Transact-SQL)
ABS (Transact-SQL)
ACOS (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
ALL (Transact-SQL)
ALTER Statements (Transact-SQL…
AND (Transact-SQL)
ANY (Transact-SQL)
APPLOCK_MODE (Transact-SQL)
APPLOCK_TEST (Transact-SQL)
APP_NAME (Transact-SQL)
ASCII (Transact-SQL)
ASIN (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL…
ASYMKEY_ID (Transact-SQL)
ASYMKEYPROPERTY (Transact-SQL)
ATAN (Transact-SQL)
ATN2 (Transact-SQL)
AVG (Transact-SQL)
BACKUP (Transact-SQL)
BACKUP CERTIFICATE (Transact-S…
BACKUP MASTER KEY (Transact-SQ…
BACKUP SERVICE MASTER KEY (Tra…
BEGIN...END (Transact-SQL)
BEGIN CONVERSATION TIMER (Tran…
BEGIN DIALOG CONVERSATION (Tra…
BEGIN DISTRIBUTED TRANSACTION …
BEGIN TRANSACTION (Transact-SQ…
BETWEEN (Transact-SQL)
binary and varbinary (Transact…
BINARY_CHECKSUM (Transact-SQL)
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST and CONVERT (Transact-SQL…
CATCH (TRY...CATCH) (Transact-…
CEILING (Transact-SQL)
CERTPROPERTY (Transact-SQL)
Cert_ID (Transact-SQL)
Change Data Capture Functions …
Change Tracking Functions (Tra…
char and varchar (Transact-SQL…
CHAR (Transact-SQL)
CHARINDEX (Transact-SQL)
CHECKPOINT (Transact-SQL)
CHECKSUM (Transact-SQL)
CHECKSUM_AGG
CLOSE (Transact-SQL)
CLOSE MASTER KEY (Transact-SQL…
CLOSE SYMMETRIC KEY (Transact-…
COALESCE (Transact-SQL)
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQ…
COL_LENGTH (Transact-SQL)
COL_NAME (Transact-SQL)
COLUMNPROPERTY (Transact-SQL)
COLUMNS_UPDATED (Transact-SQL)
COMMIT TRANSACTION (Transact-S…
COMMIT WORK (Transact-SQL)
Compound Operators (Transact-S…
COMPUTE (Transact-SQL)
CONNECTIONPROPERTY (Transact-S…
Constants (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTINUE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
Control-of-Flow Language (Tran…
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
CREATE Statements (Transact-SQ…
CRYPT_GEN_RANDOM (Transact-SQL…
CURRENT_REQUEST_ID (Transact-S…
CURRENT_TIMESTAMP (Transact-SQ…
CURRENT_USER (Transact-SQL)
cursor (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Cursors (Transact-SQL)
Data Collector Functions (Tran…
Data Types (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transac…
DATABASEPROPERTY (Transact-SQL…
DATABASEPROPERTYEX (Transact-S…
DATALENGTH (Transact-SQL)
date (Transact-SQL)
DATEADD (Transact-SQL)
DATEDIFF (Transact-SQL)
DATENAME (Transact-SQL)
DATEPART (Transact-SQL)
datetime (Transact-SQL)
datetime2 (Transact-SQL)
datetimeoffset (Transact-SQL)
DAY (Transact-SQL)
DB_ID (Transact-SQL)
DB_NAME (Transact-SQL)
DBCC (Transact-SQL)
DEALLOCATE (Transact-SQL)
decimal and numeric (Transact-…
DECLARE @local_variable (Trans…
DECLARE CURSOR (Transact-SQL)
DECRYPTBYASYMKEY (Transact-SQL…
DECRYPTBYCERT (Transact-SQL)
DECRYPTBYKEY (Transact-SQL)
DECRYPTBYKEYAUTOASYMKEY (Trans…
DECRYPTBYKEYAUTOCERT (Transact…
DECRYPTBYPASSPHRASE (Transact-…
DEGREES (Transact-SQL)
DELETE (Transact-SQL)
DENSE_RANK (Transact-SQL)
DENY (Transact-SQL)
DIFFERENCE (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
DROP Statements (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL…
ENABLE TRIGGER (Transact-SQL)
ENCRYPTBYASYMKEY (Transact-SQL…
ENCRYPTBYCERT (Transact-SQL)
ENCRYPTBYKEY (Transact-SQL)
ENCRYPTBYPASSPHRASE (Transact-…
END (BEGIN...END) (Transact-SQ…
END CONVERSATION (Transact-SQL…
ERROR_LINE (Transact-SQL)
ERROR_MESSAGE (Transact-SQL)
ERROR_NUMBER (Transact-SQL)
ERROR_PROCEDURE (Transact-SQL)
ERROR_SEVERITY (Transact-SQL)
ERROR_STATE (Transact-SQL)
EVENTDATA (Transact-SQL)
EXCEPT and INTERSECT (Transact…
EXECUTE AS (Transact-SQL)
EXECUTE AS Clause (Transact-SQ…
EXECUTE
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Expressions (Transact-SQL)
FETCH (Transact-SQL)
FILE_ID (Transact-SQL)
FILE_IDEX (Transact-SQL)
FILE_NAME (Transact-SQL)
FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
FILEGROUPPROPERTY (Transact-SQ…
FILEPROPERTY (Transact-SQL)
float and real (Transact-SQL)
FLOOR (Transact-SQL)
sys.fn_check_object_signatures…
fn_get_audit_file (Transact-SQ…
fn_get_sql (Transact-SQL)
fn_helpcollations (Transact-SQ…
fn_listextendedproperty (Trans…
sys.fn_xe_file_target_read_fil…
fn_my_permissions (Transact-SQ…
fn_servershareddrives (Transac…
fn_trace_geteventinfo (Transac…
fn_trace_getfilterinfo (Transa…
fn_trace_getinfo (Transact-SQL…
fn_trace_gettable (Transact-SQ…
fn_virtualfilestats (Transact-…
fn_virtualservernodes (Transac…
FOR Clause (Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Trans…
FULLTEXTSERVICEPROPERTY (Trans…
Functions (Transact-SQL)
geography (Transact-SQL)
geometry (Transact-SQL)
GET CONVERSATION GROUP (Transa…
GET_FILESTREAM_TRANSACTION_CON…
GET_TRANSMISSION_STATUS (Trans…
GETANSINULL (Transact-SQL)
GETDATE (Transact-SQL)
GETUTCDATE (Transact-SQL)
GO (Transact-SQL)
GOTO (Transact-SQL)
GRANT (Transact-SQL)
GROUP BY (Transact-SQL)
GROUPING (Transact-SQL)
GROUPING_ID (Transact-SQL)
HAS_DBACCESS (Transact-SQL)
HAS_PERMS_BY_NAME (Transact-SQ…
HASHBYTES (Transact-SQL)
HAVING (Transact-SQL)
hierarchyid (Transact-SQL)
Hints (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (Function) (Transact-…
IDENTITY (Property) (Transact-…
IF...ELSE (Transact-SQL)
image (Transact-SQL)
IN (Transact-SQL)
INDEXKEY_PROPERTY (Transact-SQ…
INDEXPROPERTY (Transact-SQL)
INDEX_COL (Transact-SQL)
INSERT (Transact-SQL)
int, bigint, smallint, and tin…
INTO Clause (Transact-SQL)
IS_MEMBER (Transact-SQL)
IS_OBJECTSIGNED (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL…
ISDATE (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
ISNULL (Transact-SQL)
ISNUMERIC (Transact-SQL)
Key_GUID (Transact-SQL)
Key_ID (Transact-SQL)
KEY_NAME (Transact-SQL)
KILL (Transact-SQL)
KILL QUERY NOTIFICATION SUBSCR…
KILL STATS JOB (Transact-SQL)
LEFT (Transact-SQL)
LEN (Transact-SQL)
LIKE (Transact-SQL)
LOG (Transact-SQL)
LOG10 (Transact-SQL)
LOGINPROPERTY (Transact-SQL)
LOWER (Transact-SQL)
LTRIM (Transact-SQL)
MAX (Transact-SQL)
MERGE (Transact-SQL)
MIN (Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transac…
money and smallmoney (Transact…
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQ…
NCHAR (Transact-SQL)
nchar and nvarchar (Transact-S…
NEWID (Transact-SQL)
NEWSEQUENTIALID() (Transact-SQ…
NOT (Transact-SQL)
ntext, text, and image (Transa…
NTILE (Transact-SQL)
NULLIF (Transact-SQL)
numeric (Transact-SQL)
OBJECT_DEFINITION (Transact-SQ…
OBJECT_ID (Transact-SQL)
OBJECT_NAME (Transact-SQL)
OBJECT_SCHEMA_NAME (Transact-S…
OBJECTPROPERTY (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL…
ODBC Scalar Functions (Transac…
OPEN (Transact-SQL)
OPEN MASTER KEY (Transact-SQL)
OPEN SYMMETRIC KEY (Transact-S…
OPENDATASOURCE (Transact-SQL)
OPENQUERY (Transact-SQL)
OPENROWSET (Transact-SQL)
OPENXML (Transact-SQL)
Operators (Transact-SQL)
OPTION Clause (Transact-SQL)
OR (Transact-SQL)
ORDER BY Clause (Transact-SQL)
ORIGINAL_DB_NAME (Transact-SQL…
ORIGINAL_LOGIN (Transact-SQL)
OUTPUT Clause (Transact-SQL)
OVER Clause (Transact-SQL)
PARSENAME (Transact-SQL)
PathName (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicate (Transact-SQL)
PRINT (Transact-SQL)
PUBLISHINGSERVERNAME (Transact…
PWDCOMPARE (Transact-SQL)
PWDENCRYPT (Transact-SQL)
QUOTENAME (Transact-SQL)
RADIANS (Transact-SQL)
RAISERROR
RAND (Transact-SQL)
RANK (Transact-SQL)
READTEXT (Transact-SQL)
real (Transact-SQL)
RECEIVE (Transact-SQL)
RECONFIGURE (Transact-SQL)
REPLACE (Transact-SQL)
REPLICATE (Transact-SQL)
Reserved Keywords (Transact-SQ…
RESTORE Statements for Restori…
RESTORE MASTER KEY (Transact-S…
RESTORE SERVICE MASTER KEY (Tr…
RETURN (Transact-SQL)
REVERSE (Transact-SQL)
REVERT (Transact-SQL)
REVOKE (Transact-SQL)
RIGHT (Transact-SQL)
ROLLBACK TRANSACTION (Transact…
ROLLBACK WORK (Transact-SQL)
ROUND (Transact-SQL)
ROW_NUMBER (Transact-SQL)
ROWCOUNT_BIG (Transact-SQL)
rowversion (Transact-SQL)
RTRIM (Transact-SQL)
SAVE TRANSACTION (Transact-SQL…
SCHEMA_ID (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Search Condition (Transact-SQL…
SELECT @local_variable (Transa…
SELECT (Transact-SQL)
SEND (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
SESSION_USER (Transact-SQL)
SESSIONPROPERTY (Transact-SQL)
SET @local_variable (Transact-…
SET (Transact-SQL)
SETUSER (Transact-SQL)
SHUTDOWN (Transact-SQL)
SIGN (Transact-SQL)
SignByAsymKey (Transact-SQL)
SignByCert (Transact-SQL)
SIN (Transact-SQL)
smalldatetime (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
SOME | ANY (Transact-SQL)
SOUNDEX (Transact-SQL)
SPACE (Transact-SQL)
sql_variant (Transact-SQL)
SQL_VARIANT_PROPERTY (Transact…
SQRT (Transact-SQL)
SQUARE (Transact-SQL)
STATS_DATE (Transact-SQL)
STDEV (Transact-SQL)
STDEVP (Transact-SQL)
STR (Transact-SQL)
STUFF (Transact-SQL)
SUBSTRING (Transact-SQL)
SUM (Transact-SQL)
SUSER_ID (Transact-SQL)
SUSER_NAME (Transact-SQL)
SUSER_SID (Transact-SQL)
SUSER_SNAME (Transact-SQL)
SWITCHOFFSET (Transact-SQL)
SYSDATETIME (Transact-SQL)
SYSDATETIMEOFFSET (Transact-SQ…
SYMKEYPROPERTY (Transact-SQL)
System Stored Procedures (Tran…
System Tables (Transact-SQL)
System Views (Transact-SQL)
SYSUTCDATETIME (Transact-SQL)
sys.fn_builtin_permissions (Tr…
sys.fn_translate_permissions (…
sys.fn_validate_plan_guide (Tr…
sys.login_token (Transact-SQL)
sys.user_token (Transact-SQL)
SYSTEM_USER (Transact-SQL)
table (Transact-SQL)
Table Value Constructor (Trans…
TAN (Transact-SQL)
TERTIARY_WEIGHTS (Transact-SQL…
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
time (Transact-SQL)
tinyint (Transact-SQL)
TODATETIMEOFFSET (Transact-SQL…
TOP (Transact-SQL)
Trace Flags (Transact-SQL)
Transactions (Transact-SQL)
TRY...CATCH (Transact-SQL)
TRIGGER_NESTLEVEL (Transact-SQ…
TRUNCATE TABLE (Transact-SQL)
TYPE_ID (Transact-SQL)
TYPE_NAME (Transact-SQL)
TYPEPROPERTY (Transact-SQL)
UNICODE (Transact-SQL)
UNION (Transact-SQL)
uniqueidentifier (Transact-SQL…
UPDATE (Transact-SQL)
UPDATE() (Transact-SQL)
UPDATE STATISTICS (Transact-SQ…
UPDATETEXT (Transact-SQL)
UPPER (Transact-SQL)
USE (Transact-SQL)
USER (Transact-SQL)
USER_ID (Transact-SQL)
USER_NAME (Transact-SQL)
VAR (Transact-SQL)
varbinary (Transact-SQL)
varchar (Transact-SQL)
VARP (Transact-SQL)
VerifySignedByCert (Transact-S…
VerifySignedByAsymKey (Transac…
WAITFOR (Transact-SQL)
WHERE (Transact-SQL)
WHILE (Transact-SQL)
WITH common_table_expression (…
WITH XMLNAMESPACES (Transact-S…
WRITETEXT (Transact-SQL)
XACT_STATE (Transact-SQL)
xml (Transact-SQL)
xml_schema_namespace (Transact…
YEAR (Transact-SQL)

Switch View :

ScriptFree

Data Collector Functions (Transact-SQL)

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_gettable (Transact-SQL)

See Also

Reference

Data Collector Stored Procedures (Transact-SQL)

Data Collector Views (Transact-SQL)

Management Data Warehouse Stored Procedures (Transact-SQL)

Concepts

Introducing the Data Collector