Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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: 2,430 times

last updated: 15 Mar '13, 17:13