如何更改我的用户组的azure datwarehouse中的资源类

问题描述

hi 

我面临的主要问题是，从我的用户运行的任何查询一次只运行一个查询，而其他查询正在排队。我是另一个添加了我的id的用户列表的一部分，我看到xlargerc是资源类。我怎么能把它改成mediumrc
。我获得的1000dw单位的所有查询槽的原因是28，并且一个查询正在运行，并且我看到所有其他查询已排队。我怎么能解决这个问题？

i am facing major issue where any query ran from my user is running only one query at a time while the others are being queued . I was part of another userlist where my id got added and i see xlargerc is the resource class . how i can change it to mediumrc . Reason for it all the query slots i got for 1000dw units is 28 and everything is being consumed by one query which is running and i see all others are queued . how i can i fix this?

adithya

推荐答案

您能否确认您是在Gen1还是Gen2环境中运行DWH实例？这可能是等式中的一个重要细节，但是，为了回答您的问题，您可以运行两个T-SQL：

Can you confirm if you are running your DWH instance in a Gen1 or Gen2 environment? This could be an important detail in the equation but, to answer your question, there are two T-SQLs you could run:

查看资源类和

更改用户的资源类别

请查看以下内容，因为它可以提供指导：  示例代码
用于查找最佳资源类别

Please take a look at the following as it could provide guidance: Example code for finding the best resource class

我希望这会有所帮助。

谢谢，

Mike

这篇关于如何更改我的用户组的azure datwarehouse中的资源类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！