Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: Size of Stored Procedure

    I would like to know what is the appropriate size of store procedure

    i use the formula provided by Sybase
    select (count(*) / 8) +1
    from sysprocedures
    where id = object_id("procedure1")

    The result is 1024.

    Is it a huge size and what is the value of procedure cache size ?

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

    Re: Size of Stored Procedure

    The appropriate size is : as small as possible ;-)

    The goal of this calculation is to provide a relevant number configuring the procedure cache.

  3. #3
    Join Date
    Dec 2003
    Posts
    32

    Re: Size of Stored Procedure

    what is the unit of this value, byte or kbyte?

    how do i know the procedure cache is enough ?

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

    Re: Size of Stored Procedure

    1) seems to be pages
    2) as soon as it is too small, you're receiving an error nr 701

Posting Permissions

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