Avoiding Blocking Issues in ASP.NET Session State Databases
page 2 of 2
by Greg Low
Feedback
Average Rating: 
Views (Total / Last 10 Days): 36996/ 51
Article Contents:

Conclusion

By keeping two copies of the procedure scheduled to run at five minute intervals, the expired sessions at the site were being quickly cleaned up and the blocking caused by the procedure was completely eliminated.

 

Dr Greg Low

http://msmvps.com/greglow

Greg is a Senior Consultant at Readify in Australia and heads up their SQL Server practice. He is a Microsoft Regional Director and a Microsoft SQL Server MVP.


View Entire Article

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 2:52:21 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search