Unable to generate execution plan for TSQL batch using SQL statements with "Out Parameter"
説明
The TSQL batch where the affected query is being run appears to be a dynamic SQL with "out parameter", executed by sp_executeSQL. When the SQL Server saves the batch text in such a scenario it is executable because "out parameter" can only be executed inside sp and not as a script (incorrect syntax ). Since the batch text syntax is incorrect Foglight failed to generate an execution plan. Foglight does not support generating an execution plan for batch with "out” parameter" executed as dynamic SQL, because of the way batch text is saved in SQL Server.
対策
WORKAROUND: None STATUS: Enhancement request EVO-I-39 has been submitted to be reviewed by the product team to be considered for future implementation in the latest release of Foglight
