The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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

asked 01 Jun '12, 06:54

aejaz2's gravatar image

accept rate: 0%

edited 15 Mar '13, 17:13

Mark%20Culp's gravatar image

Mark Culp

This forum is dedicated to SQL Anywhere aka SQLA. So your chances are better in an ASE specific forum. See Community Forums Search

(01 Jun '12, 07:36) Reimer Pods
Replies hidden

...or confine this forum's FAQ...

(01 Jun '12, 07:37) Volker Barth

The question has been closed for the following reason "Question is off-topic or not relevant" by Graeme Perrow 01 Jun '12, 09:44

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • 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: 1,443 times

last updated: 15 Mar '13, 17:13