Classic ASP on Windows 7, IIS 7 is SLOW!

So I have this show web app thingy that runs local. Put it on a new laptop and it ran like a dog. After sorting out the installation of classic ASP, tweaking the recycling, permissions, timeouts and everything else – I finally remembered: SQL initially uses named piped and shared memory. These sound neat and fast but they are BOFFO.

1: Edit your hosts file and add localhost
2: Go to SQL Configuration Tool, Interfaces and get rid of named pipes and shared memory.

There you go – instant fast IIS on Windows 7 with SQL 2008.