Export (0) Print
Expand All

MSSQLSERVER_8621

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Product Name

SQL Server

Event ID

8621

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

OPTIMIZER_STACK_OVERFLOW_ERR

Message Text

The query processor ran out of stack space during query optimization. Please simplify the query.

The size of the expanded query is the most likely cause of the error. The expanded query substitutes into the original query the definitions of each of the views, computed columns, Transact-SQL functions, and common table expressions it references, as well as cascading actions like updating secondary indexes, views, and triggers.

Most likely the query is large in some dimension; for example, the number of tables referenced by view definitions, or a very large scalar expression.

Simplify the query by breaking the query into multiple queries along the largest dimension. First remove any query elements that are not really necessary, then try adding a temp table and splitting the query in two. Merely moving a part of the query to a subquery, function, or common table expression is insufficient because they get recombined by the Transact-SQL compiler.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft