Spotlight is raising the following dead alarm against itself:
--------------------
Connection: <server>
Time: <time>
Severity: High
Locks - Blocked Processes: Session 67 has been blocked by session 66 for the last 90 seconds.
Blocking Details
Blocking session:
Application name: Spotlight Diagnostic Server (Playback WRITE)
Host name: <server>
OS User name:
Database User name: <user>
First 2KB of SQL: insert [dbo].[spotlight_playback_data] select * from [dbo].[spotlight_playback_data] option (maxdop 1)
Blocked session:
Database name: SpotlightPlaybackDatabase
Application name: Spotlight Diagnostic Server (Playback READ)
Host name: <server>
OS User name:
Database User name: <user>
First 2KB of SQL: (@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 nvarchar(4000),@P7 nvarchar(4000),@P8 datetime2)select pb_id, pb_domain_name, pb_timestamp, pb_me_name, pb_package_name, pb_table_name, pb_data, pb_data_compressed from spotlight_playback_data with (readpast) where pb_domain_name = @P0 and pb_me_name = @P1 and pb_package_name = @P2 and pb_table_name = @P3 and pb_timestamp = (select max(pb_timestamp) from spotlight_playback_data with (readpast) where pb_domain_name = @P4 and pb_me_name = @P5 and pb_package_name = @P6 and pb_table_name = @P7 and pb_timestamp <= @P8)
--------------------
WORKAROUND: None
STATUS: Waiting for fix in a future release of Spotlight on SQL Server Enterprise.
