What are standalone Machine Learning Server or R Server in SQL Server?

Artikkeli
08/01/2023

Applies to: SQL Server 2016 (13.x) and later versions

Important

The support for Machine Learning Server (previously known as R Server) ended on July 1, 2022. For more information, see What's happening to Machine Learning Server?

SQL Server provides installation support for a standalone R Server or Machine Learning Server that runs independently of SQL Server. Depending on your SQL Server version, a standalone server has a foundation of open-source R and possibly Python, overlaid with high-performance libraries from Microsoft that add statistical and predictive analytics at scale. Libraries also enable machine learning tasks scripted in R or Python.

In SQL Server 2016, this feature is called R Server (Standalone) and is R-only. In SQL Server 2017, it's called Machine Learning Server (Standalone) and includes both R and Python.

Note

As installed by SQL Server Setup, a standalone server is functionally equivalent to the non-SQL-branded versions of Microsoft Machine Learning Server, supporting the same user scenarios, including remote execution, operationalization and web services, and the complete collection of R and Python libraries.

Components

SQL Server 2016 is R only. SQL Server 2017 supports R and Python. The following table describes the features in each version.

Component	Description
R packages	RevoScaleR is the primary library for scalable R with functions for data manipulation, transformation, visualization, and analysis. MicrosoftML adds machine learning algorithms to create custom models for text analysis, image analysis, and sentiment analysis. sqlRUtils provides helper functions for putting R scripts into a T-SQL stored procedure, registering a stored procedure with a database, and running the stored procedure from an R development environment. olapR is for specifying MDX queries in R.
Microsoft R Open (MRO)	Microsoft R Open (retired) was Microsoft's open-source distribution of R.
R tools	R console windows and command prompts are standard tools in an R distribution. Find them at \Program files\Microsoft SQL Server\140\R_SERVER\bin\x64.
R Samples and scripts	Open-source R and RevoScaleR packages include built-in data sets so that you can create and run script using pre-installed data. Look for them at \Program files\Microsoft SQL Server\140\R_SERVER\library\datasets and \library\RevoScaleR.
Python packages	revoscalepy is the primary library for scalable Python with functions for data manipulation, transformation, visualization, and analysis. microsoftml adds machine learning algorithms to create custom models for text analysis, image analysis, and sentiment analysis.
Python tools	The built-in Python command-line tool is useful for ad hoc testing and tasks. Find the tool at \Program files\Microsoft SQL Server\140\PYTHON_SERVER\python.exe.
Anaconda	Anaconda is an open-source distribution of Python and essential packages.
Python samples and scripts	As with R, Python includes built-in data sets and scripts. Find the revoscalepy data at \Program files\Microsoft SQL Server\140\PYTHON_SERVER\lib\site-packages\revoscalepy\data\sample-data.
Pre-trained models in R and Python	Pre-trained models are created for specific use cases and maintained by the data science engineering team at Microsoft. You can use the pre-trained models as-is to score positive-negative sentiment in text, or detect features in images, using new data inputs that you provide. Pre-trained models are supported and usable on a standalone server, but you cannot install them through SQL Server Setup. For more information, see Install pretrained machine learning models on SQL Server.

Using a standalone server

R and Python developers typically choose a standalone server to move beyond the memory and processing constraints of open-source R and Python. R and Python libraries executing on a standalone server can load and process large amounts of data on multiple cores and aggregate the results into a single consolidated output. High-performance functions are engineered for both scale and utility: delivering predictive analytics, statistical modeling, data visualizations, and leading-edge machine learning algorithms in a commercial server product engineered and supported by Microsoft.

As an independent server decoupled from SQL Server, the R and Python environment is configured, secured, and accessed using the underlying operating system and standard tools provided in the standalone server, not SQL Server. There is no built-in support for SQL Server relational data. If you want to use SQL Server data, you can create data source objects and connections as you would from any client.

As an adjunct to SQL Server, a standalone server is also useful as a powerful development environment if you need both local and remote computing. The R and Python packages on a standalone server are the same as those provided with a database engine installation, allowing for code portability and compute-context switching.

How to get started

Start with setup, attach the binaries to your favorite development tool, and write your first script.

Step 1: Install the software

Install either one of these versions:

Step 2: Configure a development tool

On a standalone server, it's common to work locally using a development installed on the same computer.

Step 3: Write your first script

Write R or Python script using functions from RevoScaleR, revoscalepy, and the machine learning algorithms.

Explore R and RevoScaleR in 25 Functions: Start with basic R commands and then progress to the RevoScaleR distributable analytical functions that provide high performance and scaling to R solutions. Includes parallelizable versions of many of the most popular R modeling packages, such as k-means clustering, decision trees, and decision forests, and tools for data manipulation.
Quickstart: An example of binary classification with the microsoftml Python package: Create a binary classification model using the functions from microsoftml and the well-known breast cancer dataset.

Choose the best language for the task. R is best for statistical computations that are difficult to implement using SQL. For set-based operations over data, leverage the power of SQL Server to achieve maximum performance. Use the in-memory database engine for very fast computations over columns.

Step 4: Operationalize your solution

Standalone servers can use the operationalization functionality of the non-SQL-branded Microsoft Machine Learning Server. You can configure a standalone server for operationalization, which gives you these benefits: deploy and host your code as web services, run diagnostics, test web service capacity.

Step 5: Maintain your server

SQL Server releases cumulative updates on a regular basis. Applying the cumulative updates adds security and functional enhancements to an existing installation.

Descriptions of new or changed functionality can be found in the CAB Downloads article and on the web pages for SQL Server 2016 cumulative updates and SQL Server 2017 cumulative updates.

For more information on how to apply updates to an existing instance, see Apply updates in the installation instructions.

Jaa