Kontrollbase – queries to update your max_connections alert

If you have been reading the Kontrollbase performance reports and noticed that one alert says your connection usage vs max connections ration is too high but then recommends you to decrease the max_connections variable, then you will find this fix handy. Its two simple queries that execute on the Kontrollbase schema to update the max_connections alert name and description.

Since this particular alert’s logic was changed to display a recommendation for lowering and/or increasing the max_connections variable depending on the usage percentage, the name and description of the alert in the schema needs to be updated as well. If you prefer you can wait until the next version comes out that addresses this change, or you can run the following two queries on your Kontrollbase schema to update the information. Enjoy!

update alerts_def set alert_desc = 'Server connection usage ratio needs to be optimized.' where id = '5';
update alerts_def set alert_name = 'max_connections to max_used_connections ratio not optimal.' where id = '5';


2 Responses to “Kontrollbase – queries to update your max_connections alert”

  • 1 schema change Says:

    [...] source control when schemas change. why a schema is not the same as the DDL scripts you use to …Kontrollbase queries to update your max_connections alert …If you have been reading the Kontrollbase performance reports and noticed that one alert says your [...]

  • 2 loans Says:

    I want to thank the blogger very much not only for this post but also for his all previous efforts. I found kontrollsoft.com to be very interesting. I will be coming back to kontrollsoft.com for more information.