| title | sys.dm_external_script_execution_stats | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 09/16/2016 | ||||
| ms.prod | sql | ||||
| ms.reviewer | |||||
| ms.suite | sql | ||||
| ms.technology | |||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 2e99f026-ceb2-42a2-a549-c71d31ed0cf4 | ||||
| caps.latest.revision | 5 | ||||
| author | jeannt | ||||
| ms.author | jeannt | ||||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]
Returns one row for each type of external script request. The external script requests are grouped by the supported external script language. One row is generated for each registered external script functions. Arbitrary external script functions are not recorded unless sent by a parent process, such as rxExec.
Note
This DMV is available only if you have installed and then enabled the feature that supports external script execution. For information about how to do this for R scripts, see Set up SQL Server R services.
| Column name | Data type | Description |
|---|---|---|
| language | nvarchar | Name of the registered external script language. Each external script must specify the language in the script request to start the associated launcher. |
| counter_name | nvarchar | Name of a registered external script function. Is not nullable. |
| counter_value | integer | Total number of instances that the registered external script function has been called on the server. This value is cumulative, beginning with the time that the feature was installed on the instance, and cannot be reset. |
Requires VIEW SERVER STATE permission on server.
Note
Users who run external scripts must have the additional permission EXECUTE ANY EXTERNAL SCRIPT, however, this DMV can be used by administrators without this permission.
This DMV is provided for internal telemetry, to monitor overall usage of the new external script execution feature provided in [!INCLUDEssNoVersion_md]. The telemetry service starts when LaunchPad does and increments a disk-based counter each time a registered external script function is called.
Generally speaking, performance counters are valid only as long as the process that generated them is active. Therefore, a query on a DMV cannot show detailed data for services that have stopped running. For example, if a launcher executes external script and yet completes them very quickly, a convnetional DMV might not show any data
Therefore, the counters tracked by this DMV are kept running, and state for sys.dm_external_script_requests is preserved by using writes to disk, even if the instance is shut down.
Currently the only external script language supported in [!INCLUDEssCurrent_md] is R. External script requests for the R language are handled by [!INCLUDErsql_productname_md].
For R, this DMV tracks the number of R calls that are made on an instance. For example, if rxLinMod is called and run in parallel, the counter is incremented by 1.
For the R language, the counter values displayed in the counter_name field represent the names of registered ScaleR functions. The values in the counter_value field represent the cumulative number of instances that the specific ScaleR function.
The count begins when the feature is installed and enabled on the instance and is cumulative until the file that maintains state is deleted or overwritten by an administrator. Therefore, it is generally not possible to reset the values in counter_value. If you want to monitor usage by session, calendar times, or other intervals, we recommend that you capture the counts to a table.
The R language supports arbitrary scripts, and the R community provides many thousand packages, each with their own functions and methods. However, this DMV monitors only the ScaleR functions that are installed with SQL Server R Services.
Registration of these functions is performed when the feature is installed, and registered functions cannot be added or deleted.
The following example displays the cumulative number of external script executions for the R language.
SELECT counter_name, counter_value
FROM sys.dm_external_script_execution_stats
WHERE language = 'R';
Dynamic Management Views and Functions (Transact-SQL)
Execution Related Dynamic Management Views and Functions (Transact-SQL)
sys.dm_external_script_requests
sp_execute_external_script