Blocked processes show no data or are out of sync with graph in Playback mode. (4307149)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Blocked processes show no data or are out of sync with graph in Playback mode.
Description

The users reports an issue where he is trying to view the blocked data, and while he can see it on the graph below for the blocked processes, once selected it shows "no data" on the top drilldown.
Cause

The procedures are run one by one, even if we set the schedule to run every minute, sometimes one of the procedures will run slowly, so if it can’t run exactly in one minute when rewind to that minute maybe there is no data collected.
Resolution

WORKAROUND:
Move to one minute before or after on the playback dial, to view the blocked data, this is simply because the query took longer to run.
STATUS
Waiting for fix in the future release of Spotlight on SQL Server Enterprise.
Defect ID

SEMB-747

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title