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
I am getting max_worker_percent as 100
Any help will be highly appreciated.
Thanks in advance