since upgrading to 1.4.1 we're seeing a lot table locks.
http://screencast.com/t/lCfBOnCIt
This didn't exist before the upgrade...the problem we've had in tuning around this is that while tuning brings down load as soon as the board gets busy again it seems that everything returns to as it was and needs to be re-optimized.
This is a fairly large site that pre upgrade load was rarely over 5 on a 16 core machine early today we saw over 1200.
Any thoughts on getting this back to as it was?
http://screencast.com/t/lCfBOnCIt
This didn't exist before the upgrade...the problem we've had in tuning around this is that while tuning brings down load as soon as the board gets busy again it seems that everything returns to as it was and needs to be re-optimized.
This is a fairly large site that pre upgrade load was rarely over 5 on a 16 core machine early today we saw over 1200.
Any thoughts on getting this back to as it was?