Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Sybase slow until restart

    Hi,

    Wonder if anyone out there can help with this extremely perplexing problem.

    We have built a reporting system that does numerous complex calculations and therefore makes use of tempdb tables extensively. We have just moved over to a new server. Sometimes our reports run fine, other times extremely slowly. Sometimes a report will start off running fine and then seem to hit a wall ... running extremely slowly. Normally the server stays in this state and all other reports after will also run extremely slowly. It seems that if you leave the server for a while without anything running, the reports will run fine again later.

    We have noticed that restarting Sybase always seems to fix the problem, at least for a while.

    It seems to me that some server resource is being exhausted. I have been told that the only thing that restarting Sybase does is to clear the tempdb, however I'm told by the DBAs that we are not short on tempdb space.

    Can anybody help?

    Thanks in advance,
    Saul

    PS: We are running ASE 12.5.0.3 on SUN OS5.8.

  2. #2
    Join Date
    Nov 2003
    Location
    edison, NJ
    Posts
    4
    Instead of restarting sybase just run update statistics more frequently and do reindexing.

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    Doesn't make any difference

    We have tried running update statistics, but it doesn't seem to make any difference. It wouldn't actually since all the data needed for the report is written into temp tables before being manipulated for the purposes of the report. So indexing and statistics isn't really likely to make any difference.




    Originally posted by amarshende
    Instead of restarting sybase just run update statistics more frequently and do reindexing.

  4. #4
    Join Date
    Nov 2003
    Posts
    30

    Re: Sybase slow until restart

    you have to distinguish which report / set of reports are making the problem . It could be a particular report creating the problem. After the report finishes its execution the system is returning to normal state. Also try to run the different performance statistics at the time of problem to pin point the cause of problem.

  5. #5
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: Sybase slow until restart

    during your bottleneck, execute a sp_sysmon

  6. #6
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    sp_sysmon is the best way to go.

    Is the data being populated to temp tables is a lot ? Then try creating indexes on these temp tables after populating them.

  7. #7
    Join Date
    Sep 2003
    Location
    London
    Posts
    12
    There is a bug involving connections that hang when dropping temp tables on this release of ASE, which might be worth checking out (especially since the resolution is a re-start....)
    Here is a link:-
    http://www.sybase.com/detail/1,6904,1025581,00.html
    Will

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •