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

aejaz2
0111
accept rate: 0%

edited 15 Mar '13, 17:13

Mark%20Culp's gravatar image

Mark Culp
23.3k9132275

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×51

question asked: 01 Jun '12, 06:54

question was seen: 1,298 times

last updated: 15 Mar '13, 17:13