How StackOverflow Scales SQL Server

[utubesqueeze]

Summary:

- "Everybody's the DBA", i.e. top-down performance tuning

- MVC profiling, i.e. application-oriented tuning

- Memcached/Reddis/AppFabric query-result elective caching

- Apache Lucene or equivalent

- RAID SSD, IO performance with reliability

- share because you and everyone learns faster, and it is not your core competency anyway.

Light bulb moment (20:59 - 25:29): - "Tune later, Cache & Separate Now", i.e. identify and separate what is truly a query and what is calculation.

Thanks!