Last year at Pageflakes, when we were getting millions of hits per day, we were having query timeout due to lock timeout and Transaction Deadlock errors. These locks were produced from aspnet_Users and aspnet_Membership tables. Since both of these tables
Read More...
Read the complete post at http://feedproxy.google.com/~r/OmarAlZabirBlog/~3/dddCH2jA0Qk/optimize-asp-net-membership-stored-procedures-for-greater-speed-and-scalability.aspx