Редактиране

Споделяне чрез


SQL Server, External Scripts object

Applies to: SQL Server

The SQLServer:External Scripts object in SQL Server provides counters to monitor the actions associated with executing external scripts. For information about executing external scripts, see sp_execute_external_script (Transact-SQL).

This table describes the SQL Server External Scripts counters.

SQL Server External Scripts counters Description
Execution Errors The number of errors in executing external scripts.
Implied Auth. Logins The number of logins from satellite processes authenticated by using implied authentication.
Parallel Executions The number of external scripts executed with @parallel = 1.
Partition By Executions Number of external scripts executed with @input_data_1_partition_by_columns parameter.
SQL CC Executions The number of external scripts executed using SQL Compute Context.
Streaming Executions The number of external scripts executed with the @r_rowsPerRead parameter.
Total Execution Time (ms) The total time spent in executing external scripts.
Total Executions The number of external scripts executed.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%External Scripts%';