"Foreground only" in the SQL Sever sessions panel shows background processes (4372989)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

"Foreground only" in the SQL Sever sessions panel shows background processes
Description

When the "foreground only" checkbox is enabled in the Sessions dashboard of the SQL Server agent, background processes with a SPID higher than the number 50 are still displayed.

"Foreground only" enabled displays background SPIDs higher than 50. SPIDs at 50 or lower are hidden.

"foreground only" turned off displays background all of the SPIDs
Cause

In early versions of SQL Server (prior to 2005 or 7.0 [released in 1998]) the system processes were limited to less than fifty (< 50). In more recent SQL Server releases it is common for (background) system processes to have SPID numbers of 50.

SPID =<50 are always system processes. However, system processes can still exist in SPIDs > 50.
Resolution

Workaround

None

Status

Defect ID FOG-6667 has been logged for the "Foreground only" checkbox in the Sessions panel to hide SPIDs higher than 50. This has been added to the 7.3 release of the SQL Server cartridge.
Defect ID

FOG-6667

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title