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