"Foreground only" in the SQL Sever sessions panel shows background processes
説明
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
原因
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.
対策
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.
