Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Set/extend kernel shared memory parameters Expand / Collapse
Author
Message
Posted Thursday, September 1, 2011 6:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 1:49 PM
Points: 45, Visits: 345
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
Posted Thursday, September 1, 2011 11:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 1:49 PM
Points: 45, Visits: 345
Anyone?
Post #1168804
Posted Thursday, September 1, 2011 11:14 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 39,866, Visits: 36,208
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
Posted Thursday, September 1, 2011 11:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 1:49 PM
Points: 45, Visits: 345
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
Posted Thursday, September 1, 2011 12:45 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 39,866, Visits: 36,208
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 »

Add to briefcase

Permissions Expand / Collapse