IIS 7 and Above
Does app pool recycling cause database roll backs?
Last post Jul 05, 2018 02:50 AM by deepakpanchal10
Jul 04, 2018 05:06 PM|noodles57|LINK
I had to throttle the CPU down to 50%.
I run an app pool recycle every 4 hours.
The recycling seems to work for regaining speed, but is it possibly causing any database edits I do to roll back? There is one table I'm manually editing using SSMS. I click on each cell and make the edits and click away from the cell. This should commit
the changes - correct? For the past few days these changes revert back to what was there and I can't figure it out.
Also there a bigger reason my site runs slowly? Every time I try to run the source code in Visual Studio it throws an exception, sort of a loop is happening I was told.
Jul 04, 2018 08:35 PM|lextm|LINK
In such short paragraphs you revealed a C# site with multiple issues (slow, high CPU, broken database access). And most importantly, you don't seem to be able to troubleshoot.
Please consider escalating the issues to someone who can, such as a senior member in your team, or simply Microsoft support, by opening a support case via
I am afraid a forum like this won't help, as any serious troubleshooting requires either server access or source code access.
Jul 05, 2018 02:50 AM|deepakpanchal10|LINK
You had mentioned that,"There is one table I'm manually editing using SSMS. I click on each cell and make the edits and click away from the cell. This should commit the changes - correct? For the past few days these changes revert
back to what was there and I can't figure it out."
Many reasons that can cause this issue.
First you can check that "Auto Commit" is turned on in your SSMS. By default it is turned on but it can be possible that some other user had turn it off and you are not aware about it.
To check the same you can go to Tools menu and select options.
Query Execution->SQL Server-> ANSI.
check that 'Set Implicit transection' check box is unchecked.
If it is checked then uncheck it and again try to make a test.
Further, try to use the query in SSMS to modify or insert new records and after that execute the
commit in your query.
Then recycle your App pool and check whether the modified data are available or not.
Data get roll back if transection is running and your App pool get recycled.
But if it is already commit in SSMS then App pool recycle will not make any effect on it.
Other thing, You had mentioned that when you run the code in Visual Studio you got an loop related error.
It is possible that your code is executing a very long loop or an infinite loop which slow down your site.
Try to debug your code on your development machine and check whether it is caused by your code and if yes then try to correct it may help you to improve the performance.