| title | SQL Server, External Scripts object | ||
|---|---|---|---|
| description | Learn about the SQLServer:External Scripts object, which provides counters to monitor the actions associated with executing external scripts. | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| ms.date | 12/04/2023 | ||
| ms.service | sql | ||
| ms.subservice | performance | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
The SQLServer:External Scripts object in [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] 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. |
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%';