1k is not nearly enough for a full blown production server. There are some internal dbcc's that can force metadata reuse. Otherwise you will see the dataserver scavanging objects causing all sorts of problems.
The best option is to increase the config parameter to something reasonable. These metadata resource (memory) requirements from object descriptors are negligible. An increase by a few thousands probably would cost you 60-100KB of memory. use sp_monitorconfig to check the peak usage.
I had a look at the total metaobjects in the server they are about 25K of them.. So I should be theorotically setting the value of open objects to 25K + another 5% overhead (as per documentation).
However the point I am intrested is when are these open objects closed ?. Or are they open until the data server is recycled ?.
As per my observation BCP tends to leave open objects in the system and the only option after one runs out of object desc is restarting of the Adap. server ?. Is there anyway one can close these objects ? Is there a work around rather than increasing the config param ?
The objects are held open until the data server is recycled. An open object has a internal descriptor. If the descriptor is reused any stored procedures using the old descriptor will need to be recompiled - Slowing your application.
It is better to allocate the small amount of memory required to open objects (indexes & databases) than allocate it to other sorts of cache.
sybase advises "number of open objects sets the maximum number of objects that can be open simultaneously on Adaptive Server" ..
Currently we have run out of 8K in about 3 days. I am sure our application cannot use that many objects "simultanesously".. Is there a catch somewhere ??..
Currently at peak time my server shows me about 412 objects open.. I assume 412 open objects simultaneously... why is it that at peak usage I see a max of 412 objects being used and can run out of 8K in 3 days ...what type o operations result in such huge usage..
Is there any way we can look at open objects being accessed currently..
Name Num_free Num_active Pct_act Max_Used Reused
------------------------- ----------- ----------- ------- ----------- ------
number of open objects 7588 412 5.15 412 No