Post reply

Set/extend kernel shared memory parameters

  • September 1, 2011 at 6:56 am

    #247228

    Hi,

    Our application is receiving an intermittent error: "Please set/extend kernel shared memory paramters This is required for database locking mechanisms"

    I analyzed some perfmon parameters and got some interesting informations, for example: the database pages are oscillating a bit and the Free Pages is constantly below the threashold (640).

    The server is a 32-bit Windows 2003 R2, with 4 GB of RAM (1,5 GB to SQL Server) with 8 processors.

    All other SQL Server and resource metrics are OK.

    Does anyone know what this error might be? I didn't find any relevant information about it.

    Thanks

  • September 1, 2011 at 11:09 am

    #1376071

    Anyone?

  • September 1, 2011 at 11:14 am

    #1376075

    That's not a SQL Server error. I'd contact the application vendor.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 1, 2011 at 11:24 am

    #1376082

    Thanks! That's what I wanted.

    They see anything related to database and they think the problem is with the SQL Server.

    Do you have any article/white paper regarding this error?

    Thanks

  • September 1, 2011 at 12:45 pm

    #1376120

    I'm not likely to have a whitepaper about a strange error from an unknown application.... Ask the vendor what, in their application, causes that error.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply