SQL Server CTP3 Integrated R Language installation configuration guide

1. Scope of application

SQL server CTP3 A single-machine R integrated Deployment guidance manual for Windows server TP3

Non-domain environment, r non-clustered

2. Installation Preparation 2.1 Hardware preparation

MSDN recommends a minimum of 1GB of memory, but we consider that R requires a lot of memory to calculate so it is recommended at least 4GB

2.2 Software Preparation

Revolution R Open 3.2.2 for Revolution R Enterprise 7.5.0

http://go.microsoft.com/fwlink/?LinkId=626650

Revolution R Enterprise 7.5

http://go.microsoft.com/fwlink/?LinkId=626652

SQL Server CTP3

http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/

3. Start the installation configuration 3.1 Revolution R open installation

The Rro can be connected directly to the analysis work after installation, but only for the traditional R analysis designer

3.2 Revolution R Enterprise Node SQL installation (2 option 1)

Only compute nodes, called via SQL 2016, no VS2008 design interface

Installing the necessary components through the wizard

Start Rre node installation after all necessary components have been installed

3.3 Revolution R Enterprise Installation (2 option 1)

With VS2008 design interface, you can use SQL 2016 and VS2008 to edit R scripts simultaneously on the server

Error message said not found MSVCR120.dll, this DLL file is located in Visual C + + redistributable Packages for Visual Studio 2013, we can solve in two ways:

L Download and install Visual C + + redistributable Packages for visual Studio X86 with X64 installation package

L Install VS2013-based SSDT directly (optional SQL 2014 SSDT installation)

Install Rre 7.5.0 after SSDT is installed to install verification through components and install VS2008 shell automatically, which is an integrated traditional RRE development interface

Off-topic: Notice that the previous PowerPivot for SharePoint was missing because of the move, and when you install the Analysis service you will find that there are now 3 options

Note two places:

L SQL Server Launchpad This service is actually the Advanced Analytics Services and MSDN inconsistencies, this should be a small bug, do not care

This grant Perform Volume maintenance Task privilege to SQL Server service recommendation Tick is used primarily to create large data files without having to format the file volume to elevate the initial The speed of initiation. For example, creating a new 16GB data file in a database requires a background format of about 10 seconds, now almost 0 seconds, but note that this parameter is not valid for the LDF log file, so the log file also has to initialize a large value and try to prevent it from automatically expanding.

P.S. It should be recommended to also add the locked memory page, so that after the installation is complete and then change

More than one tempdb initial configuration card, in fact, have been tuned DBA used to be their own T-SQL configuration, here is just an auxiliary means

Legend Report Service has a major improvement, later experience, and this article is not related to the topic

I'll play it later in the test, it's nothing to do with this article.

Polybase is our next topic, discuss it later, install it first

Start the installation.

3.5 Configuring R functions

4. Verifying the installation

RRE running successfully

For such an ugly designer is also unable to spit groove, I hope RTM can become a good point, if you simply write r script individual or recommend Rstudio, beautiful, suitable, check function use method are very convenient

T-SQL Call R

5. References

Installing SQL Server R Services

https://msdn.microsoft.com/library/mt604883 (sql.130). aspx

Microsoft MPI

https://msdn.microsoft.com/en-us/library/bb524831 (v=vs.85). aspx

Hardware and software Requirements for installing SQL Server 2016

Https://msdn.microsoft.com/en-us/library/ms143506.aspx#pmosr

Install R Packages and Providers for SQL Server R Services

Https://msdn.microsoft.com/en-us/library/mt590809.aspx

Install Advanced Analytics Extensions

Https://msdn.microsoft.com/en-us/library/mt590808.aspx

post-installation server Configuration (SQL Server R Services)

Https://msdn.microsoft.com/en-us/library/mt590536.aspx

Known Issues for SQL Server R Services

Https://msdn.microsoft.com/en-US/library/mt590540.aspx

Visual C + + redistributable Packages for Visual Studio 2013

http://www.microsoft.com/en-US/download/details.aspx?id=40784

Download Latest SQL Server Data Tools

Https://msdn.microsoft.com/en-us/library/mt204009.aspx

Revolution R Enterprise 7.5.0 (RRE-7.5.0)

https://www.microsoft.com/en-us/download/details.aspx?id=49505

Revolution-r-enterprise-node-sql-7.5.0-windows.exe. On a server running SQL Server, install the this to create a n R server with SQL Server support. You can run R packages on the server and the server can also accept requests from remote clients.

Revolution-r-enterprise-sql-7.5.0-windows.exe. Same as above, but adds an R IDE. Install this in a server if you want your development tools and servers on the same computer. Install this in a client workstation to create a complete R development environment integrated with SQL Server 2016.

Revolution R Open 3.2.2 for Revolution R Enterprise 7.5.0

https://www.microsoft.com/en-us/download/details.aspx?id=49525

Configure and Manage Advanced Analytics Extensions

https://msdn.microsoft.com/en-us/library/mt590869.aspx?f=255&MSPPError=-2147217396

Security Considerations for the R Runtime in SQL Server

Https://msdn.microsoft.com/en-US/library/mt590870.aspx

SQL Server R Services Tutorials

Https://msdn.microsoft.com/en-US/library/mt591993.aspx

This article is from the "Fast" blog, so be sure to keep this source http://greece760.blog.51cto.com/660798/1708710

SQL Server CTP3 Integrated R Language installation configuration guide