Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2002
    Posts
    3

    Smile Unanswered: !!!memory usage in procedure headers (2)

    I find a warning message in my errorlog file.
    can you tell me what's the meaning about this?

    01:00000:00011:2002/09/03 17:43:45.19 server WARNING: memory usage in procedure headers (2)
    does not match memory usage count in Pss (0) for server process id 11.

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Shirleen

    1 What is your @@version ?
    2 What is spid 11 (internal or user) ?

    Derek
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  3. #3
    Join Date
    Sep 2002
    Posts
    3
    first, thans for your reply.

    my sybase version is:

    Adaptive Server Enterprise/12.0.0.4/P/SWR 10045 ESD 2/Sun_svr4/OS 5.7/1789/64bit/FBO/Tue Feb 5 01:57:37 2002

    and this process id:11 is a normal user process.

    is this a os bug?

  4. #4
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Shirleen

    1 You are out-of-date with EBFs for 12.0. You should have a minimum of 12.0.0.5 (which I have), 12.0.0.4 is superceded. I trust it is not a production server. Get updated fast.
    2 Basically the server is running out of process headers (which can be easily changed with sp_configure) but the warning is internal corruption. Not O/S corruption. The condition may or may not deteriorate.

    Derek
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  5. #5
    Join Date
    Sep 2002
    Posts
    3
    1.It is a 7*24 running system. I can't shutdown it anyhow.
    2.Can i raise my ASE version to 12.0.0.5 if I patch the system using the new EBFs?
    3.Can I fix the warning using the command sp_configure ,what shall i do?

    thank you so much!

  6. #6
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Originally posted by shirleen
    2.Can i raise my ASE version to 12.0.0.5 if I patch the system using the new EBFs?
    Yes, applying EBFs will raise the version. That is the normal method.
    Note you should not upgrade a production server with an EBF that you have not fully tested in a test environment.
    3.Can I fix the warning using the command sp_configure ,what shall i do?
    Not sure what you mean, you cannot "fix the warning" but you can avoid the warning in future (I am mobile and not connected to any of my servers at this moment, so I cannot give you exact parameter identification, look it up):
    exec sp_configure "proc headers", <new_value>
    with the usual procedures.

    You have to figure out <new_value> based on a number of factors (load, type of usage, etc) at your site. For your situation, you can safely double the old_value.

    I would recommend you upgrade "stack size" and "stack guard size" as well.

    Derek
    Last edited by DerekA; 09-18-02 at 00:27.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

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