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 = NOP Expand / Collapse
Author
Message
Posted Wednesday, August 6, 2008 6:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 13, 2011 10:05 PM
Points: 271, Visits: 45
Hi All,

Can somebody let me know when do you get Command=NOP in sp_who2.

I have seen Insert, Update, Delete etc but have never seen NOP and it seems today was the day when I had to come across this.

Please let me know how to resolve the problem.

Thanks,

Tushar Chheda
Post #547449
Posted Wednesday, August 6, 2008 7:13 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 6:35 AM
Points: 282, Visits: 2,211
I think it means "no operation was performed".



MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Post #547479
Posted Wednesday, August 6, 2008 11:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 13, 2011 10:05 PM
Points: 271, Visits: 45
Hi,

Is there any way we can check which process led to the NOP command.
In my scenario this happened when there was no activity on the DB Box.

Thanks,

Tushar Chheda
Post #548007
Posted Thursday, August 21, 2008 5:13 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:52 PM
Points: 417, Visits: 764
I also getting this when I'm calling an .sql file thru SQLCMD, that particular SPID shows NOP some time and INSERT as well after. Im getting exact clue on this.

Experience tips may help.

Jay.


Thanks
Jay
http://www.sqldbops.com
Post #556983
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse