Browse by Tags

All Tags » sql server » performance (RSS)
Fri, Mar 13 2009 14:23

Optimize ASP.NET Membership Stored Procedures for greater speed and scalability

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...
Posted by omar | 8 comment(s)
Filed under: , , ,
Sat, Mar 7 2009 7:30

Linq to SQL solve Transaction deadlock and Query timeout problem using uncommitted reads

When your database tables start accumulating thousands of rows and many users start working on the same table concurrently, SELECT queries on the tables start producing lock contentions and transaction deadlocks. This is a common problem in any high volume...
Posted by omar | 14 comment(s)
Filed under: , , ,
Wed, Dec 10 2008 8:39

99.99% available ASP.NET and SQL Server SaaS Production Architecture

You have a hot ASP.NET+SQL Server product, growing at thousand users per day and you have hit the limit of your own garage hosting capability. Now that you have enough VC money in your pocket, you are planning to go out and host on some real hosting facility...
Posted by omar | 4 comment(s)
Filed under: , , , , ,
Wed, Sep 19 2007 8:46

A significant part of sql server process memory has been paged out. This may result in performance degradation

If you are using SQL Sever Server standard edition 64 bit on a Windows 2003 64bit, you will frequently encounter this problem where SQL Server says: A significant part of sql server process memory has been paged out. This may result in performance degradation...
Posted by omar | 33 comment(s)
Filed under: , , , ,
Sun, Mar 25 2007 19:39

Cleanup inactive anonymous users from ASP.NET Membership Tables

ASP.NET 2.0 Websites that allow anonymous visit and anonymous user profile have a unique challenge to cleanup unused data which is generated by anonymous users who never come back. Every first visit is creating one anonymous user, page setup, and other...
Posted by omar | 31 comment(s)
Filed under: , ,