cancel
Showing results for 
Search instead for 
Did you mean: 

What is the meaning of Reuse_cnt in sp_monitorconfig

anudeepsp
Explorer
0 Kudos

Hi friends,

Could some explain what is "Reuse_cnt" and how this is helpful in configuring the parameters.?

Adaptive Server Enterprise/16.0 SP02 PL01/EBF 25184 SMP/P/x86_64/Enterprise Linux/ase160sp02pl00/2424/64-bit/FBO/Thu Sep 17 22:46:42 2015

Accepted Solutions (1)

Accepted Solutions (1)

former_member89972
Active Contributor
0 Kudos

Hi Anudeep

Above Mark has already provided some excellent tips.

First and foremost put a batch job to record the results of "sp_monitorconfig 'all'" "sp_countmetadata" periodically (every hour may be !).

Ideally if you can recycle the server to reset the re-use and max-used counters that will be great, so that you start with a clean slate.

If not, use the figures last recorded to see the upward trend if any.

So increase the number of open objects by 100K when you first see the (climb) of reuse count.

And then with that base line keep increasing in steps until reuse count steadies.

Investigate the processes during the particular window when you notice climbing used count. As Mark pointed out if it is due to temporary objects then in your configuration cater to that or accept a small performance hit ( until user(s) start shouting !!)

Also watch errorlog for any messages asking for reconfiguration. E.g. if number of locks run out, it is recorded in the ASE errorlog.

HTH

Avinash

Answers (2)

Answers (2)

anudeepsp
Explorer
0 Kudos

Thank Avinash and Mark for your valuable suggestion. It helped a lot.

Regards,

Anudeep

former_member89972
Active Contributor
0 Kudos

Check the if a particular configuration value is marked as reused indicated by "yes" in the report.

Then look at the max used value.

Add your buffer / fudge factor and then use this new value as value to be configured.

E.g. "number of open" indexes, objects may be under configured. If number is under configured, descriptors may be written to disk and the reused for next session(s). This can impact performance of one or more queries.

DBAs typically run sp_monitorconfig "all" and watch for under / over configured values.

This needs to be run especially during peak hours to note the configuration tweaks needed.

HTH

Avinash

anudeepsp
Explorer
0 Kudos

Hi Avinash,

Thank you for your response.

Below is the situation for number of open objects -

Configured value - 300000

Max_Used - 300000

Reuse_cnt - 95686

Could you please help me how much should i configure?

FYI...

1> sp_countmetadata 'number of open objects'
2> go
There are 83325 user objects in all database(s), requiring 1101462 Kbytes of memory. The 'open objects' configuration parameter is currently set to 300000.