Post reply

DMV sys.dm_exec_sessions lists Multiple SA Logins

  • September 28, 2010 at 10:42 am

    #147102

    This si probably a dumb question but when I use the DMV sys.dm_exec_sessions I get a listing of all my logins (when doing a COUNT() of Session_ID that is grouped by Login_name) that includes 26 instances of SA. When i look closely at these all are as best as I can tell, totally inactive.

    What are these for? is there a default number of SA connections (as far as this DMV is concerned) always running??

    I've been working with the DMVs more now that our key system is moving to support a higher verison of SQL then 2000 and this one seemed a bit oddd to me. Any input is welcome.

    Thanks

    Kindest Regards,

    Just say No to Facebook!

  • September 28, 2010 at 12:12 pm

    #1228577

    Did you exclude system processes? (WHERE is_user_process = 0)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 28, 2010 at 1:30 pm

    #1228635

    GilaMonster (9/28/2010)

    Did you exclude system processes? (WHERE is_user_process = 0)

    I did not Gail but I do now. Thanks. I knew it was a dumb question. It would be so easy to forest if it weren't for those darn Trees.

    Kindest Regards,

    Just say No to Facebook!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply