Technology is always great its up to who uses it. Something like if you give baby a gun, he will either shoot you or himself.

To know how one can design the high perfomance system follow below links.

1. Scalable apps with Asynchronous Programming in ASP.NET
    http://msdn.microsoft.com/en-us/magazine/cc163463.aspx

2. Network load balancing (Web farming using asp.net)
    http://www.west-wind.com/presentations/loadbalancing/NetworkLoadBalancingWindows2003.asp

3. Performance application pool settings
    http://msdn.microsoft.com/en-us/library/aa720391(VS.71).aspx

4. SQL server hints
   http://www.sql-server-performance.com/tips/hints_general_p1.aspx

5. asp.net process model
   http://quickstarts.asp.net/QuickStartv20/aspnet/doc/management/processmodel.aspx

6. Application pool and worker process
   http://www.revenmerchantservices.com/post/2010/03/10/Application-Pool-and-Worker-process.aspx
   http://www.developer.com/net/asp/article.php/2245511
   http://www.windowsnetworking.com/articles_tutorials/Working-Application-Pools-Internet-Information-Server.html