If you're curious as to what kind of hardware, what company's Web server, and what the most popular database the biggest Internet sites run on, ZDNet has an article profiling what the big boys run in this article. Although there are some pretty interesting combinations (LookSmart has SQL server on Sun?) the most common theme seems to be Sun hardware with Apache serving the webpages and Oracle serving up the backend.