Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jul 22nd, 2012  |  syntax: None  |  size: 0.44 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. stored procedure taking lot of time in Sybase ASE 15.5
  2. 1> sp_monitor "event","133"
  3. 2> go
  4.  WaitTime Description                                        
  5.  -------- --------------------------------------------------
  6.    216900 waiting for incoming network data                  
  7.     86000 waiting on run queue after yield                  
  8.      1200 wait for i/o to finish after writing last log page
  9.       600 waiting for last i/o on MASS to complete