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

Server roles in SQL Server 2016

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

Problem

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.

Solution

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

  • PDW, Integration Services and Resource Classes



  • 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:

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

Code Snippets

smallrc
mediumrc
largerc
xlargerc

Context

StackExchange Database Administrators Q#103562, answer score: 10

Revisions (0)

No revisions yet.