In coming versions with the change, the script no longer collected the SQL directly from Extended Events and instead Spotlight will grab the plan handle. This means more events could fit into the XML document. Spotlight will then post process the results and use the plan handle to get the SQL either from SQL Server or from a cache of SQL that the Diagnostic Server maintains.
STATUS: Issue fixed in version 11.6.2. The latest version of Spotlight on SQL Server Enterprise can be downloaded at https://support.quest.com/spotlight-on-sql-server-enterprise/download-new-releases
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center