Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    41

    Unhappy Unanswered: Stored Procedure performance

    This is the scenario. We have Sybase ASE 12.5.0.3 on Solaris 8. We have two sets of similar database, one on Dev unix machine and another on Prod unix machine. The data in both databases are same, and the configuration parameters of both the instances are same. We are running a Stored Proc in Dev which takes like 3mins to run. But the same Stored Proc in Prod runs for 20 mins.

    Can anybody tell us why this happens? The memory configuration in both the instances are same.
    Thans in Advance
    ====================
    Rajesh

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    The reasons I could think of

    a) Locking contentions
    b) Statistics not up to date // common error
    c) indexes missing on the tables referred

Posting Permissions

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