Monitor Python and R script execution using custom reports in SQL Server Management Studio
Use custom reports in SQL Server Management Studio (SSMS) to monitor the execution of external scripts (Python and R), resources used, diagnose problems, and tune performance in SQL Server Machine Learning Services.
In these reports, you can view details such as:
- Active Python or R sessions
- Configuration settings for the instance
- Execution statistics for machine learning jobs
- Extended events for R Services
- Python or R packages installed on the current instance
This article explains how to install and use the custom reports provided for SQL Server Machine Learning Services.
For more information on reports in SQL Server Management Studio, see Custom reports in Management Studio.
How to install the reports
The reports are designed using SQL Server Reporting Services, but can be used directly from SQL Server Management Studio. Reporting Services does not have to be installed on your SQL Server instance.
To use these reports, follow these steps:
Download the SSMS Custom Reports for SQL Server Machine Learning Services from GitHub.
Copy the reports to Management Studio
Locate the custom reports folder used by SQL Server Management Studio. By default, custom reports are stored in this folder (where user_name is your Windows user name):
C:\Users\user_name\Documents\SQL Server Management Studio\Custom Reports
You can also specify a different folder, or create subfolders.
Copy the *.RDL files you downloaded to the custom reports folder.
Run the reports in Management Studio
In Management Studio, right-click the Databases node for the instance where you want to run the reports.
Click Reports, and then click Custom Reports.
In the Open File dialog box, locate the custom reports folder.
Select one of the RDL files you downloaded, and then click Open.
The SSMS Custom Reports repository in GitHub includes the following reports:
|Active Sessions||Users who are currently connected to the SQL Server instance and running a Python or R script.|
|Configuration||Installation settings of Machine Learning Services and properties of the Python or R runtime.|
|Configure Instance||Configure Machine Learning Services.|
|Execution Statistics||Execution statistics of Machine Learning services. For example, you can get the total number of external scripts executions and number of parallel executions.|
|Extended Events||Extended events that are available to get more insights into external scripts execution.|
|Packages||List the R or Python packages installed on the SQL Server instance and their properties, such as version and name.|
|Resource Usage||View the CPU, Memory, IO consumption of SQL Server, and external scripts execution. You can also view the memory setting for external resource pools.|