- You execute a query against sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by using an outer join in Microsoft SQL Server 2012.
- You mismatch the join criteria like joining sql_handle to plan_handle.
- You export a report to PDF with Unicode fonts, such as Arial Unicode MDS or Lucida Sans Unicode.
When you try to close the SPID, it results in a non-yielding scheduler error and no visible change to the state of the server. In this situation, SQL Server will freeze when you try to restart the instance and the only way that resolves the problem is to restart Windows.
Service pack information for SQL Server 2012To resolve this problem, obtain the latest service pack for SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2930239 - Last Review: 5 May 2014 - Revision: 1