DBCC LOGINFO on SQL 2005 causes “non-yielding processes on scheduler” errors and server timeouts
If you are using DBCC LOGINFO in the production environment and you are lucky enough to still have an instance of SQL Server 2005 which, suddenly out of the blue, started throwing “non-yielding processes on scheduler” errors into the error…