I had created a new kentico instance by moving copying code files from one server to new server and configured the site properly , everything is working fine but for every 2 or 3 days I'm getting an SQL error.
Then i'm doing app pool refresh in IIS whenever that problem encounters, then the site working , so anybody please give me the permanent solution .
What is the SQL query that throws an error and what is the actual error? - I'd start my investigation from there
There is Recommended Application Pool Configuration from Kentico
that you can follow.
You can set up a pool recycling at IIS level for example once in 24 hours during the night when you have the lowest traffic.
P.S. We have our site recycling once per 24hrs.
If your app pool is being forced to restart or keeps crashing, there is most likely some sort of syntax error in your custom code or a custom SQL statement. We have many sites which do not restart for weeks or months on end.
I'd start with the event log from Kentico, then work to the IIS event log, then go to the SQL event log to see what is causing the issue.
Thanks for responding guys.
Hi Brenden , i think there is no error in Custom code, because it works fine in first server.
I'm getting this after i just moved the code to another server.
This was the error i'm getting , suggest any solution.
Found these in the event log.
Please, sign in to be able to submit a new answer.