HiveBrain v1.2.0
Get Started
← Back to all entries
principlesqlMinor

What are exact benefits of using R services on Enterprise vs Standard?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
exactwhatarestandardservicesenterprisebenefitsusing

Problem

I am currently using SQL Server 2016 SP standard edition and want to install R services. In the documentation is said that a stand alone installation is allowed only on Enterprise (Machine Learning Server (Standalone)).

Also, I found a post, where the guy is talking that on standard I am not able to use parallel operations and there are memory limitations:

Could anyone tell what are the exact memory/processors limitations?

I need such details as going to use heavy R calculations and the tests for now show that the implementation in the standard edition is not working as I hoped.

Solution

Check out the "Feature availability across editions of SQL Server Machine Learning Services" page of Books Online:


The difference between basic and advanced integration is scale.
Advanced integration can use all available cores for parallel
processing of data sets at any size your computer can accommodate.
Basic integration is limited to 2 cores and to data sets fitting in
memory.

Books Online goes into more details on that page about deployment restrictions as well like:


Only a (Standalone) server offers the operationalization features that
are included in a Microsoft (non-SQL-branded) R Server or Machine
Learning Server installation. Operationalization includes web service
deployment and hosting capabilities.


For an (In-Database) installation, the equivalent approach to
operationalizing solutions is leveraging the capabilities of the
database engine, when you convert code to a function that can run in a
stored procedure.

Context

StackExchange Database Administrators Q#213199, answer score: 6

Revisions (0)

No revisions yet.