A
Andriy Mishin
Guest
Hello, I'm trying to learn how to manage performance in an OpenEdge database. I've set up a monitoring system. And I decided to start with setting the -spin parameter. With the database works from 1.7K to 3.2К users depending from time of day. On the database server we have 128 CPU. Several databases are running on the same server. Currently the value of -spin is set to 10000 for all databases. On the monitoring system I set following thresholds for Latch timeouts: less than 300 - Ok(Green zone); more that 300 and less than 500 - Warning (Yellow zone); more than 500 - Critical (Red zone). I've noticed that most databases have the Latch timeouts value in the green zone (less than 300). But in one database, the values of Latch timeouts are almost always in the red zone. On average 809, max 1.5 K. The question is, should I increase or decrease the -spin value for this database? Or maybe I should pay attention to some other metrics? Thanks in advance for any tips!
Continue reading...
Continue reading...