Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBCowboy
Starting Member
26 Posts |
 Posted - 2003-05-29 : 13:52:48
|
| While attempting to solve a problem with slow running queries at a particular time of day, we saw the following from an SP_WHO2 run...COMMAND: NOP CPUTime: 123474 DiskIO: 4180 LastBatch: 05/29 10:38:00 ProgramName: SQLAgent - TSQL JobStep (Job 0xB999613B7DF38D48AAFE274C1A0E515B : Step 1) SPID: 558 I'm used to seeing INSERT, SELECT, UPDATE, etc as the COMMAND but I can't find a single reference to "NOP" in BOL or Microsoft's site. I'm guessing it's a system command of some sort... but what is it? I've searched through the procedures called by the job and can't find the word there, so it's not something intentionally introduced that I'm aware of. I'm just curious, so any speculation would be appreciated.Jaysen |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Command: NOP