Don't know if the title is relevant or not for the article, but here is the story. Couple of days ago, more exactly at round 4 start, I migrate Ysabel from Windows 2000 server/SQL Server 2005 to a brand new machine having Windows 2003 server 64 bit and SQL Server 2005.

Everything was perfect at the beginning, for about 24 hours. And then, into a beautiful Saturday the nightmare begins. Users were contacting me saying that the site is extremely slow or don't work at all - and they were right. My first suspicion was related to IIS that was consuming a large amount of memory (at least 5 times more than the good old server). Site has it's own pool, and after every IIS restart or pool recycle everything comes back to normal for 5-10 minutes.

I tried every possible combination in IIS to try make it work, but nothing helped - and that was my beautiful night. Next day early in the morning, with a fresh mind I realized that all static pages are working! Only pages (unfortunately 95%) containing database calls didn't respond in time. I stopped blaming IIS, and looked at SQL Server. After killing a couple of sleeping sessions, site was back again! But only for a little while. And that gives me the answer - I just modified connection string to increase pool size and everything gets back to normal - and still no problem after more than 1 week.