Avoiding Blocking Issues in ASP.NET Session State Databases: ASP Alliance

ASP.NET Tutorials » Avoiding Blocking Issues in ASP.NET Session State ...

Not Logged In. Login

AspAlliance
Register
Edit My Profile
Author List
Write for Us
About AspAlliance
Contact Us
Privacy Policy
Link To Us
Advertise

Subscribe
Free Newsletter
Newsletter Archive
RSS Syndication

.NET Tutorials
Learn .NET
Learn WCF
Learn WPF
Learn ASP.NET
Learn AJAX
Learn Silverlight
Learn Visual Studio
Learn ADO.NET
Learn LINQ
Learn C# (CSharp)
Learn VB.NET
Learn Web Services
Learn Controls
Learn BizTalk
Learn SharePoint
Learn Mobile
Learn SQL
Learn SQL Reporting
Learn Windows Forms
Learn XML
Learn Crystal Reports
Learn FarPoint
Learn DevExpress
Examples
ASP.NET 2.0 Examples

ASP Tutorials
Learn ASP
Learn VBScript
Learn JScript
Learn SQL
Learn XML

Software Resources
Shopping Cart Ecommerce
Charts and Dashboards

Other Resources
Learn Java
Learn Oracle
Opinion / Editorial
Crystal Reports Alliance
WPF Resources
AJAX Resources
Silverlight Resources

Free Tools
Cache Manager
SimpleCMS

Reviews
Book Reviews
Product Reviews
Expert Advice

Books
ASP.NET Developer's Cookbook
Sample Chapters
Book Reviews

Community
Regular Expressions

Print Add To Favorites Email To Friend Rate This Article
Avoiding Blocking Issues in ASP.NET Session State Databases

page 2 of 2

by Greg Low
Feedback

Average Rating:

Views (Total / Last 10 Days): 36151/ 38

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.

« (Page 1)

View Entire Article

User Comments

No comments posted yet.

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