Return
-
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
Defect ID FOG-6667 has been logged for the "Foreground only" checkbox in the Sessions panel to hide SPIDs higher than 50. This will be fixed in a future release of the SQL Server cartridge.
Status -
Defect ID
FOG-6667