none
SQL Server VS BigData RRS feed

  • Question

  • Hello,

    I have millions of users will interact against the sql,

    I developed the applications against sqlServer 2016,

    Can sql server these million users with no problems ?

    Is it Suitable for bigdata or should i change the sqlServer ?

    Thnx,

    khalil

    Sunday, February 12, 2017 12:31 PM

Answers

  • The instance on the data science VM is licensed for development purposes only. For a production system serving millions of users, you can use SQL Server 2016 but you will need to run on  separate servers (sufficiently scaled up) and either bring your SQL Server license or use a SQL Server VM that is licensed for production purposes like the one here below:

    https://azuremarketplace.microsoft.com/en-us/marketplace/apps/Microsoft.SQL2016SP1-WS2016

    Thursday, March 2, 2017 9:35 PM

All replies

  • The instance on the data science VM is licensed for development purposes only. For a production system serving millions of users, you can use SQL Server 2016 but you will need to run on  separate servers (sufficiently scaled up) and either bring your SQL Server license or use a SQL Server VM that is licensed for production purposes like the one here below:

    https://azuremarketplace.microsoft.com/en-us/marketplace/apps/Microsoft.SQL2016SP1-WS2016

    Thursday, March 2, 2017 9:35 PM
  • Hi Gopi.

    I know this is a year further on down the line, hoping you are still around. Do you perhaps know how the the distinction between production and development is made?

    If a data scientist is using the SQL server to support a small team (say 5 data scientists) using the data for 'development' of a predictive model that will be used in production eventually. Is this development or production? They are all sharing one instance of the data on one of the VMs but each has their own VM instance for modelling.

    Thursday, June 7, 2018 3:52 AM