6

There are 3 new server roles in SQL Server 2016:

  • mediumrc
  • largerc
  • xlargerc

Any idea what these are for? Google doesn't give any information about these.

enter image description here

  • 4
    They sound more like internal names of pre-release provisions of Azure SQL Databases or Azure VMs. Anyway, nobody can answer your question as written, so please provide more information. Where did you read about these server roles? – Aaron Bertrand Jun 9 '15 at 3:41
10

These terms are not new to SQL 2016, but they are also not server roles as far as I know.

For all i know these are pre-built Parallel Data Warehouse resource classes.

There isn't much documentation on that except some blog posts.

Have a look at these

  1. PDW, Integration Services and Resource Classes
  2. A teched presentation from Channel 9

I only heard about these in some presentation though, I have never worked with PDW so I can't help you any more than this.

Edit

Just adding in one additional resource (direct link to download PPT) SQL Server 2012 Parallel Data Warehouse. You are basically controlling who gets more "speed" with processing by what role they are members of, at least from what I gather. The last slide in the deck:

enter image description here

Edit

In the meantime an article on workload management has been posted in the Azure documentation: Concurrency and workload management in SQL Data Warehouse where the following is mentioned (thanks Bob Klimes):

SQL Data Warehouse exposes four different resource classes in the form of database roles as part of its workload management implementation.

The roles are:

smallrc
mediumrc
largerc
xlargerc
| improve this answer | |
  • 1
    Thanks Tom. But those terms are in the server roles, I have added a screenshot of it for reference. – Zinx Jun 9 '15 at 19:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.