sp_who

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  March 10, 2010 at 3:01 am

  #137592

  Hi,

  Have a question, when i issue a BACKUP cmd for a database and issue the sp_who cmd,

  instead of showing one entry for spid = 57, why it is showing 3 entries.

  Why can't it show's only 1 entry in the output.

  This is not the case of BACKUP Command. I have also observed for other commands.

  Can anyone give any specific reasons for this ??????

  backup database dcdbset2

  to disk = 'd:\Test_db.bak'

  sp_who

  --output

  /*

  spid ecidstatusloginnamehostnameBlkdbnamecmd

  570runnable saMACHINE-1 0 Test_db BACKUP DATABASE

  572runnable saMACHINE-1 0 NULL BACKUP DATABASE

  571runnable saMACHINE-1 0 NULL BACKUP DATABASE

  */

  Thanks in Advance.

• sanketahir1985

  SSCarpal Tunnel

  Points: 4473

  More actions

  March 10, 2010 at 3:04 am

  #1131223

  this indicates Parallelism

  ur query is going in parallel operations

  this is possible when u have more than 1 CPU

  Sanket Ahir
  Don't run behind the success, Try to be eligible & success will run behind u......

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  March 11, 2010 at 2:16 am

  #1131879

  Thank You