|
We are running a stored procedure in Sybase ASE 15.5. It is taking a long time to execute (about 1 hr), however this issue is randomly reproduced i.e some times it runs within few minutes. Please find the output of sp_monitor captured on that spid ehen it was occuring. 1> sp_monitor "event","133" 2> go WaitTime Description -------- -------------------------------------------------- 216900 waiting for incoming network data 86000 waiting on run queue after yield 1200 wait for i/o to finish after writing last log page 600 waiting for last i/o on MASS to complete |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 01 Jun '12, 06:54
question was seen: 2,394 times
last updated: 15 Mar '13, 17:13
This forum is dedicated to SQL Anywhere aka SQLA. So your chances are better in an ASE specific forum. See Community Forums Search
...or confine this forum's FAQ...