Geek Answers Handbook

Azure Sql request limit reached, although the number of connections is well below the resource limit

We have several Java applications that use the shared Azure Sql database through JDBC. Each application has a pool of connections to this database. The number of connections in the pool is limited, so the total number of connections from all applications is significantly lower than the resource limit database .

Recently, we often get these types of exceptions:

com.microsoft.sqlserver.jdbc.SQLServerException: Resource ID: 1. The query limit for the database is 200 and has been reached. See ' http://go.microsoft.com/fwlink/?LinkId=267637 ' for help

  • We tested the use of the profiler so that applications do not open more connections than allowed.
  • We also checked that the correct number of applications was running, so the number of connections should be below the resource limit.
  • One strange thing we noticed was that it sp_whoshows a large number of connections, the column is Loginempty: enter image description here

Any guesses as to what might be causing these errors?

Edit:

One theory we have is related to the Sql Server MaxDOP parameter .

-, 1, Sql Server . , sp_who Login , . , () , , , , .

Edit2:

-, Azure Sql Max Parallelism 0 () .

Edit3:

. SELECT * FROM sys.resource_stat . , max_worker_percent 100%. .

+4
2

, MaxDop, , .

Sql , . , , , ( )

Azure SQL , , OPTION (MAXDOP 1) , ( parallelism ).

" ", .

+1

Sql DB Max DOP. ALTER DATABASE SCOPED CONFIGURATION T-SQL https://msdn.microsoft.com/en-us/library/mt629158.aspx

+1

More articles:


All Articles