When you execute the sys.dm_db_log_space_usage statement on a database snapshot in an instance of SQL Server 2016 and 2017, an assertion failure and then a non-yielding scheduler error occur.
This fix is included in the following cumulative updates for SQL Server:
About SQL Server 2016 builds
Each new build for SQL Server 2016 contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology Microsoft uses to describe software updates.