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.Dynamic Access Control intro on Windows Server blog
First published on TechNet on May 22, 2012 Hey all, Ned here with a quick “xerox” post: the Dynamic Access Control developers have released a good intro on their octo-feature through the Windows Server Blog:Introduction to Windows Server 2012 Dynamic Access ControlIt’s written by Nir Ben-Zvi, a Program Manager on the Windows Server development team.
