Home Forums SQL Server 2008 SQL Server 2008 - General login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2 RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

  • August 31, 2011 at 3:09 pm

    #1375732

    Marios Philippopoulos (8/31/2011)

    I noticed that there are 3 threads for that session: 3 records returned. Why would that be?

    3 threads? You're not joining to any views that deal with threads. Do each of the three rows have different request IDs? If so, EF is making use of MARS (Multiple Active Result Sets). If not, then something odd is going on or you're using a different version of the query than the one you posted.

    --
    Adam Machanic
    whoisactive