azure dw限制错误

Question

我安排了大约70个并发查询，使用70个登录来对Azure DW (DWU 200)进行压力测试，一段时间后开始收到这个错误

[Execute SQL Task] 
Error: Executing the query "SELECT Distinct S.[Nurse ID],S.[Trust Code],S.[Loc..." failed with the following error: "110802;An internal DMS error occurred that caused this operation to fail. 
Details: 
Exception: Microsoft.SqlServer.DataWarehouse.DataMovement.Workers.DmsSqlNativeException, Message: NativeOdbcConnection.Open, error in OdbcConnectionCreate: SqlState: HY000, NativeError: 10928, 'Error calling: SQLExecDirect(hstmt, (SQLWCHAR *) L"SELECT @@SPID", SQL_NTS), SQL return code: -1 | 
SQL Error Info: SrvrMsgState: 1, SrvrSeverity: 20,  Error <1>: ErrorMsg: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Resource ID : 1. The request limit for the database is 1600 and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance. | 
ConnectionString: Driver={pdwodbc};APP=TypeC01-DmsNativeReader:DB22\mpdwsvc (69820)-ODBC;Trusted_Connection=yes;AutoTranslate=no;Server=\\.\pipe\DB.22-f8e91ff83e68\sql\query, ConnectionPooling: 1 | Error calling: pConn->Create(connectionString, useConnectionPooling, packetSize, connectionLoginTimeout, environmentSettings, spid) | state: FFFF, number: 19183, active connections: 266', Connection String: Driver={pdwodbc};APP=TypeC01-DmsNativeReader:DB22\mpdwsvc (69820)-ODBC;Trusted_Connection=yes;AutoTranslate=no;Server=\\.\pipe\DB.22-f8e91ff83e68\sql\query".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

但是我找不到相应的1600限制，我也不能理解我怎么会达到它？任何帮助都将不胜感激，谢谢。

Answer 1

你读过Azure.com上的concurrency article吗？您正在对规模级别的70个并发查询进行压力测试，根据设计，这些请求将开始排队。我怀疑，在整个负载测试过程中，排队的请求队列一直在增加，直到命中系统中的某个limits。我希望您达到的限制是打开会话的数量。

如果你想确认这一点，那么你需要打开一个support ticket。但是，如果您希望在饱和负载测试中运行70个并发查询，我还建议将DWU增加到一个更高的数字。