This sample provides custom reports for SQL Server R Services that can be viewed from SQL Server Management Studio. The reports can be used to view configuration information, resource usage, execution statistics, active sessions and other information about R Services.
About this sample
Before you begin
Run this sample
Sample details
Related links
- Applies to: SQL Server 2016 (or higher)
- Key features:
- Workload: SQL Server R Services, SQL Server Machine Learning Services
- Programming Language: T-SQL, R, Python
- Authors: Umachandar Jayachandran
- Update history: Custom reports for SQL Server Machine Learning Services to show configuration, resource usage & statistics.
To run this sample, you need the following prerequisites.
Software prerequisites:
- SQL Server 2016 with R Services installed
- SQL Server 2017 or higher with Machine Learning Services installed
- SQL Server Management Studio
Installation instructions for Machine Learning Services can be found here.
To use custom reports from SQL Server Management Studio, follow the instructions from "Add a custom report to Management Studio" topic in SQL Server Books Online.
Custom reports for Machine Learning Services allow you to perform the following tasks from Object Explorer in SQL Server Management Studio. Add the reports to the server name in Object Explorer.
- Configuration of Machine Learning Services feature after Installation
- View list of R or Python packages installed on the SQL Server instance
- View resource usage of external scripts and resource governance settings
- View list of extended events for Machine Learning Services
- View execution statistics for external scripts
- View sessions that are currently executing external scripts
This report can be used to view the installation settings of Machine Learning Services and properties of the R or Python runtime. You can also use this report to configure Machine Learning Services after installation.
This report lists the R or Python packages installed on the SQL Server instance and properties like version, name.
This report can be used to view the CPU, Memory, IO consumption of SQL Server & external scripts execution. You can also view the memory setting of external resource pools.
This report can be used to view the extended events that are available to get more insights into external scripts execution.
This report can be used to view the execution statistics of Machine Learning services. For example, you can get the total number of external scripts executions, number of parallel executions and frequently used RevoScaleR functions.
For additional content, see these articles:
SQL Server Machine Learning Services - Upgrade and Installation FAQ