Set/extend kernel shared memory parameters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Set/extend kernel shared memory parameters

Set/extend kernel shared memory parameters

Rate Topic

Display Mode

Topic Options

Author

Message

rafa.aborges

Posted Thursday, September 01, 2011 6:56 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:48 AM
Points: 40, Visits: 211

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

Post #1168632

rafa.aborges

Posted Thursday, September 01, 2011 11:09 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:48 AM
Points: 40, Visits: 211

Anyone?

Post #1168804

GilaMonster

Posted Thursday, September 01, 2011 11:14 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:15 PM
Points: 37,651, Visits: 29,903

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1168809

rafa.aborges

Posted Thursday, September 01, 2011 11:24 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:48 AM
Points: 40, Visits: 211

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

Post #1168817

GilaMonster

Posted Thursday, September 01, 2011 12:45 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:15 PM
Points: 37,651, Visits: 29,903

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 2008, MVP
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

Post #1168858

« Prev Topic | Next Topic »

Permissions