Comments
-
We have had a similar problem. We run into the issue every few months and I'm not sure what triggers the condition. Typically we will either truncate the largest table or the issue will subside after a few consecutive intervals where maintenance does run. The suggestion from support is lower retention or truncate tables.…
-
We did a recent upgrade from 12.1 to 12.2 in our QA environment. The upgrade was a lot easier than going from 11.x to 12.x and 12.0 to 12.1. The "gotcha" for us is the requirement that you need to use a non-domain admin account to run the installation. Note, you do not need this to run the configuration wizard. The upgrade…
-
Still working on the case. We did find that the HA licenses are corrupting the license store. If we reset all the licenses and rebuild the HA pools; then reapply the non-HA license the system will run fine. As soon as we apply the HA licenses, it corrupts the license store. I'll update the thread once we solve the issue.
-
I found this post doing some research on HA. We implemented HA in QA and PR. Here is my feedback: * Why did you get it? Our customer wanted high availability.* We had skepticism but the customer wanted to be able to check off the box to say their services are redundant. * How did you convince your company it is necessary?…
-
I have a contact over on the Solarwinds DEV team that gave me this query which is in fact the correct syntax. This will look at the LastHeartbeatTimeStamp and if this is greater than 1 hour show the result. SELECT HostName, LastHeartbeatTimeStamp FROM Orion.HA.PoolMembers WHERE MINUTEDIFF(LastHeartbeatTimeStamp,…
-
I found some other threads - DB Maintenance - How to Handle It When Some Tables Have Tens of Millions of Rows? We had a similar problem with our 2nd instance a few months ago and it was due to the traps table(which we have since turned off traps). After we truncated this table we haven't had any problems since that time.