https://www.theeggeadventure.com/wikimedia/index.php?action=history&feed=atom&title=Sybase_Wait_Time 2026-05-13T10:34:33Z Revision history for this page on the wiki MediaWiki 1.46.0-beta https://www.theeggeadventure.com/wikimedia/index.php?title=Sybase_Wait_Time&diff=2062&oldid=prev 2009-02-18T19:59:07Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw-interface=""> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:59, 18 February 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53">Line 53:</td> <td colspan="2" class="diff-lineno">Line 53:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>280        wait for access to a memory manager semaphore    6        0       </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>280        wait for access to a memory manager semaphore    6        0       </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:Sybase]]</ins></div></td></tr> <!-- diff cache key egge_wikimedia-mw_:diff:1.41:old-2061:rev-2062:php=table --> </table>

Egge https://www.theeggeadventure.com/wikimedia/index.php?title=Sybase_Wait_Time&diff=2061&oldid=prev 2009-02-18T19:58:52Z

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

Egge