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 127.0.0.1 localhost
2: Go to SQL Configuration Tool, Interfaces and get rid of named pipes and shared memory.
3: ADD TCP/IP
There you go – instant fast IIS on Windows 7 with SQL 2008.