Sybase Wait Time: Difference between revisions
m (New page: View Sybase wait statistics. <pre> select m.WaitEventID, Description, Waits, WaitTime from master..monSysWaits m, master..monWaitEventInfo i where m.WaitEventID = i.WaitEventID order by W...) |
mNo edit summary |
||
Line 53: | Line 53: | ||
280 wait for access to a memory manager semaphore 6 0 | 280 wait for access to a memory manager semaphore 6 0 | ||
</pre> | </pre> | ||
[[Category:Sybase]] |
Latest revision as of 15:59, 18 February 2009
View Sybase wait statistics.
select m.WaitEventID, Description, Waits, WaitTime from master..monSysWaits m, master..monWaitEventInfo i where m.WaitEventID = i.WaitEventID order by WaitTime desc go WaitEventID Description Waits WaitTime ----------- -------------------------------------------------- --------- -------- 250 waiting for incoming network data 70854798 27254031 179 waiting while no network read or write is required 93414367 2325785 61 hk: pause for some time 311942 1689658 19 xact coord: pause during idle loop 19466 1168148 260 waiting for date or time in waitfor command 152675 1047502 150 waiting for semaphore 743317 1009986 104 wait until an engine has been offlined 19464 584165 178 waiting while allocating new client socket 38378 582737 57 checkpoint process idle loop 9820 580129 215 waiting on run queue after sleep 234418185 226379 251 waiting for network send to complete 25663824 199600 214 waiting on run queue after yield 15773352 70661 29 wait for buffer read to complete 13548968 69280 85 wait for flusher to queue full DFLPIECE 47507 47802 171 waiting for CTLIB event to complete 10958844 45664 55 waiting for disk write to complete 9839302 34484 124 wait for someone else to finish reading in mass 2646255 18590 51 waiting for disk write to complete 2353154 12464 31 wait for buffer write to complete 1514035 6864 92 waiting for i/o (read or write) to complete 896883 6651 33 wait for buffer read to complete 721452 4397 54 waiting for disk write to complete 256991 3338 36 wait for mass to stop changing 267528 2024 52 waiting for disk write to complete 198160 1955 41 wait to acquire latch 57234 1167 272 waiting for lock on PLC 48922 743 99 wait for data from client 7386 349 35 wait for buffer validation to complete 1086 13 91 waiting for i/o (read or write) to complete 500 13 230 waiting for site handler to complete setup 31 6 70 waiting for device semaphore 57336 5 83 wait for DES state is changing 35 2 143 pause to synchronise with site manager 684 1 34 wait for buffer write to complete 1 0 37 wait for mass to finish changing 142 0 53 waiting for mass to finish changing 3761 0 84 wait for checkpoint to complete 2 0 157 wait for object to be returned to pool 16 0 181 wait for connection to be completed 31 0 234 site handler waiting to be created 31 0 268 waiting for native thread to finish 62 0 280 wait for access to a memory manager semaphore 6 0