Hi All,
Just recently we've been experiencing serious performance problems on our website. Looking into the logs it appears that "GetNewSessionKey" and "SetVariable" methods are frequently timing out. We recently upgraded to 12.5 but were experiencing performance problems before the upgrade. Site has been performing well for months but has suddenly ground to a halt. Any ideas what might be causing these methods to timeout?
Thanks
Huw, my money is on your t_web_session_session table being too large. Have you checked the size of the table? If that's the problem, there's a utility that cleans it out, don't have the name on the tip of my tongue. You'll want to do it sooner rather than later, because we had our whole site collapse under these timeouts in the past.