conceptr980 Posted February 16, 2022 Share Posted February 16, 2022 (edited) @LFA if you could help with global script to be set when memory and virtual memory exceeded its limit in the server. My formula for Memory limit vs Virtual limit is: Memory limit * 1.5 = Virtual Memory Limit I found a global script for restarting the service https://help.tcadmin.com/Restart_service_if_used_more_than_x_cpu_or_memory_for_the_last_3_queries This previous script has limited to what memory and virtual memory used. Meanwhile , we all know that once memory limit is applied and exceeds its limit it will start eating from virtual memory so i set virtual memory as well for this case. Now we need that once virtual memory exceeded its limit, the service stops or restarted as global script since i believe with the previous scenario the server will basically crash meanwhile i want it to be stopped instead and send an email to the users says that memory limit is been exceeded (basically to give a reason to the user). Your assistance would be highly appreciated. Note: I posted this thread in the wrong section, please move me to the correct one. Thx Edited February 16, 2022 by conceptr980 Link to comment Share on other sites More sharing options...
Dennis Posted February 17, 2022 Share Posted February 17, 2022 I don't think you can do that using the Memory Limit and Virtual Memory Limit settings. Once the service has hit it's virtual memory limit, it will crash - it has no more available memory to do anything. You could instead create a custom variable that decides how much variable a service is allowed to use (this is done by ticking the "Max memory" checkbox in the variable settings). After creating the variable, you can create a custom rule in Query Monitoring that detects if the service is using more than 1.5 times the allowed memory limit, and if so restart the service and send the customer an email. Link to comment Share on other sites More sharing options...
conceptr980 Posted February 17, 2022 Author Share Posted February 17, 2022 Thank you for your reply .. I thought of something similar but i thought i should share this topic first as maybe someone else has something better than sudden crash. Thank you Dennis Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now