When you click on SQL Activity | Sessions in Spotlight for SQL Server Enterprise, there are DB Names missing from sessions with Windows accounts.
There is a DB Name for the running/active sessions, but when it returns to a sleeping state, the DB Name disappears.
However, all the SA system processes, even while in a sleeping state, continue to show the DB Name for master.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center