Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_who2 command menu is set option on Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2014 3:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:46 AM
Points: 95, Visits: 280
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:

SPID Status BlkBy Command CPUTime DiskIO LastBatch ProgramName
54 sleeping . AWAITING COMMAND 15 0 4/15/2014 12:34 .Net SqlClient Data Provider
56 sleeping . AWAITING COMMAND 0 0 4/15/2014 12:33 .Net SqlClient Data Provider
57 sleeping . AWAITING COMMAND 0 0 4/15/2014 12:34 .Net SqlClient Data Provider
59 sleeping . AWAITING COMMAND 0 0 4/15/2014 12:33 .Net SqlClient Data Provider
60 sleeping . AWAITING COMMAND 452 411 4/15/2014 11:32 Microsoft SQL Server Management Studio
63 sleeping . AWAITING COMMAND 0 0 4/15/2014 12:34 .Net SqlClient Data Provider
64 sleeping . AWAITING COMMAND 0 0 4/15/2014 12:33 .Net SqlClient Data Provider
65 RUNNABLE . SET OPTION ON 0 0 4/15/2014 12:34 .Net SqlClient Data Provider
66 sleeping . AWAITING COMMAND 0 0 4/15/2014 12:34 .Net SqlClient Data Provider

Post #1561795
Posted Tuesday, April 15, 2014 6:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1561831
Posted Tuesday, April 15, 2014 8:42 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:46 AM
Points: 95, Visits: 280
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
Post #1561915
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse