Hi ,

I have lot of web applications running on Hyper V servers with 1 Common SQL state server. Lot of users hit the applications all though there is limited information save in session state, i always see high work load on dbo.tempgetstateitemexclusive3,dbo.tempinsertstateitemshort,dbo.tempupdatestateitemshort & dbo.tempupdatestateitemlong in new relic for Production environment.
I have researched and found that the Jobs created for ASP state runs very often and creates deadlock and the articles suggest to modify the exisiting logic - which i am hesitant to do so .
Article:
http://darrenkopp.com/posts/2013/04/10/Playing-with-fire-Optimizing-the-ASPState-internals/
Changes:
https://gist.github.com/darrenkopp/5352163

My application uses Ne ...

Go to the complete details ...