戻る
-
タイトル
The response is slow under the SSIS packages page when clicking on the "Executions All" link. -
説明
The response is slow under the SSIS packages page when clicking on the "Executions All" link. -
原因
The "SampleSize" is hard coded to be 30 in the code to get execution steps, sometimes this causes performance issues.
Enhancement SSFOG-1305 was logged for this issue.SSFOG-1305: Make the "SampleSize" in execution steps sql to be configurable
-
対策
Enhancement request number SSFOG-1305 has been added to the 5.9.5.10 and higher releases of the SQL Server cartridge to configure the SampleSize in the Agent Status Properties (ASP).
The new ASP value is "Last N execution steps for calculating statistics in SSIS package" and the default is now 10.
