Post reply

sp_who2 command menu is set option on

  • April 15, 2014 at 3:47 am

    #292444

    Hi all,

    When running sp_who2, it appears one of my SQL commands is blocking but waiting on a process that is "SET OPTION ON" . This doesn't make any sense.

    What does it mean by this option:

    SPIDStatusBlkByCommandCPUTimeDiskIOLastBatchProgramName

    54sleeping .AWAITING COMMAND1504/15/2014 12:34.Net SqlClient Data Provider

    56sleeping .AWAITING COMMAND004/15/2014 12:33.Net SqlClient Data Provider

    57sleeping .AWAITING COMMAND004/15/2014 12:34.Net SqlClient Data Provider

    59sleeping .AWAITING COMMAND004/15/2014 12:33.Net SqlClient Data Provider

    60sleeping .AWAITING COMMAND4524114/15/2014 11:32Microsoft SQL Server Management Studio

    63sleeping .AWAITING COMMAND004/15/2014 12:34.Net SqlClient Data Provider

    64sleeping .AWAITING COMMAND004/15/2014 12:33.Net SqlClient Data Provider

    65RUNNABLE .SET OPTION ON 004/15/2014 12:34.Net SqlClient Data Provider

    66sleeping .AWAITING COMMAND004/15/2014 12:34.Net SqlClient Data Provider

  • April 15, 2014 at 6:11 am

    #1706056

    I do not see any blocking.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 15, 2014 at 8:42 am

    #1706134

    I am Not askin about blocking. when I run sp_who2 , i got in command menu SET OPTION ON . I want to know , what does it mean.

    Thanks

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

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