Session List doesn't display blocking SPID beyond 2000
説明
By default the SQL Activity | Session List collects the top 2000 SPIDs. As a result any blocking SPIDs beyond 2000 doesn't get displayed in the Session List even though you can see them user SQL Activity | Blocking.
対策
STATUS: Enhancement request has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.