Lesson Learned #466:Managing SQL Server Workloads:Resolving Error Msg 10928 with DAC and SQL Queries
Dealing with SQL Server's error Msg 10928 is critical for database administrators. This error, indicating that the request limit for the database has been reached, can halt operations. Recently, a customer reported encountering this error: "Msg 10928, Level 20, State 1, Line 1 Resource ID: 1. The request limit for the database is 60 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance" This situation has prevented them from identifying the application responsible for this overload, consequently disrupting connectivity with other applications.
