question

swarnava2004 avatar image
swarnava2004 asked

Request limit for the database has been reached

My Azure sql server has pricing tool as : Elastic general purpose.

In most of the times while writing the DB(inserting data in- multiple tables at same time) getting an error : "Sql error number: 10928. Error Message: Resource ID : 1. The request limit for the database is 2400 and has been reached."

MaxDROP value is 8

while inserting data in multiple table, if I execute this query:

SELECT end_time, avg_cpu_percent, max_worker_percent, max_session_percent

FROM sys.dm_db_resource_stats;

I am getting max_worker_percent as 100


Any help will be highly appreciated.


Thanks in advance

error-message
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered

If you haven't found the answer to this as I know it's an older thread, but I believe the only answer here is to scale the elastic pool to a higher vcore count. The higher the core count the more worker threads you'll get.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.