Return
-
Title
Workload Analysis has a long loading delay and results in Error retrieving data: ClientConnectIssue: A task was canceled." -
Description
When clicking on Workload Analysis, there is long loading delay and something follow by the error "Error retrieving data: ClientConnectIssue: A task was canceled." -
Cause
The Diagnostic Server maybe out of memory. Adjust the SpotlightDiagnosticServer.ini file to increase the memory limit of the Diagnostic Server. -
Resolution
WORKAROUND:
1. Backup the file {Diagnostic Server dir}\Agent\bin\SpotlightDiagnosticServer.ini into a different directory
2. Edit the file3. Change "-Xmx4096m" to "-Xmx8192m"4. Save the file5. Restart the Diagnostic Server service
STATUS:
A fix is available in the latest version of Spotlight on SQL Server Enterprise which can be downloaded here. -
Defect ID
SOSSE-6451