cancel
Showing results for 
Search instead for 
Did you mean: 

memory for lock, open object

Former Member
0 Kudos

From error log, ASE ask to increase number of open object. If I increase following configuration:

number of open object

number of lock

what is the memory for those change? how much memory should be increased for this increase?

For example, change number of lock from 25000 to 50000, then how to reconfigure memory for this change?

Former Member
0 Kudos

Thanks, Mark. If increase number of open object from 5000 to 10000, then which part of memory should be reconfigured for this increase. I have enough memory available for reconfiguration(message from sp_configure memory).

Mark_A_Parsons
Contributor
0 Kudos

sp_configure 'number of open objects',10000

ASE will automatically allocate free/available memory to the 'number of open objects' configuration parameter.

Accepted Solutions (0)

Answers (0)