This is a discussion on Re: lock table overflow within the Informix forums, part of the Database Server Software category; --> The customer's server has 1GB of ram. Unfortuately, it also is the web server, so IIS is running on ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| The customer's server has 1GB of ram. Unfortuately, it also is the web server, so IIS is running on it. I upped the buffers to 400 and the locks to 40000. The service reported: 08:47:27 Onconfig parameter RA_PAGES modified from 4 to 8. 08:47:27 Onconfig parameter RA_THRESHOLD modified from 2 to 4. I don't know how far I should push it. > > Only 200 BUFFERS seems a bit too few . . .. how much physical memory > is on your server? > > Any way to see what process is hitting the ovrlock condition?? > sending to informix-list |