SQL Server CTP3 Integrated R Language installation configuration guide

Source: Internet
Author: User
Tags sql 2014 ssdt


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


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.