Technical Questions Technical questions on Kentico CMS Connector for Microsoft SharePoint.
Kentico CMS Connector for Microsoft SharePoint > Technical Questions > Excess Kentico Calls on SQL View modes: 
User avatar
Member
Member
vobrenovic-hotmail - 11/7/2010 1:39:33 AM
   
Excess Kentico Calls on SQL
Hello,

I'm experiencing a strange problem that I don't know how to fix.

When our website falls (usually due to large traffic volume) we are unable to bring it back up for a period of time.

The reason seems to be that Kentico keeps querying the SQL Server (that works in the background) up until the SQL server runs out of memory.

Our gut feeling is that all the requests that were made prior to website falling down, Kentico keeps somewhere in memory and then requests from SQL to process them with a delay, pretty much creating a cumulative load effect with no return IP (almost a self generated DOS attack)

Does anyone have any idea where could this come from or what would be a good place to start looking?

Thanks

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 11/11/2010 1:24:11 AM
   
RE:Excess Kentico Calls on SQL
Hi,

Have you tried to kill the application or its process? Or recycle the application pool?
This is very strange and it seems that something went into a loop.
Have you used SQL profiler to see which queries are being called?
Also, could you please use the debugging options in Kentico to see what exactly is going on there?

Are there any errors logged in the Windows events or in Kentico CMS in Site Manager -> Administration -> Event log?

Best regards,
Juraj Ondrus