How StackOverflow Scales SQL Server
Loading...
Loading...
9,409
Loading...
Uploaded by BrentOzar on Nov 15, 2011
The most popular tech Q&A site in the world serves 12-14 million web pages per day with Microsoft SQL Server 2008 R2. They're passionate about performance, and we'll share the scalability lessons they learned along the way.
This session is aimed at production DBAs who manage SQL Servers that need to go faster and SQL programmers who don't understand why their database won't deliver queries quicker. You'll learn the basic infrastructure behind StackOverflow.com, the decisions made along the way while building the infrastructure, and how to tell when you need to make infrastructure and coding changes in order to scale.
- 40 likes, 0 dislikes
-
- 56:29
Best of SQL Server 2012by SoCalDevGal1,910 views
- 13:28
Troubleshooting SQL Server Slowness using SQLDiag & SQLNexusby SQLServerPlanet1,908 views
- 5:18
How to Find Slow SQL Server Queriesby BrentOzar7,381 views
- 8:26
Microsoft SQL Server Index Architectureby AlexRosaVideos8,966 views
- 2:39
Stack Overflow Careersby StackCareers616 views
- 45:58
SQL Performance Optimizationby questsoftware72,037 views
- 51:34
Quest Software - SQL Server DMVs: Performance Tuning for Intermediate Usersby questsoftware3,402 views
- 0:17
Jenna Marbles Face in Action!by TheStephtfischer989,141 views
- 2:23:00
Quest Software - Blitz! SQL Server Takeovers with Brent Ozarby questsoftware2,285 views
- 4:25
Indian cricket teams top ten fight'sby krishanpratap100522,637 views
- 29:59
There's Something About Nolockby BrentOzar988 views
- 3:52
The Death of The Lich King Cinematic World of Warcraft WOTLKby ArthasMenethil441,315,136 views
- 9:17
SQL Server 2008 and using Transact SQL (TSQL)by baghul21,995 views
- 2:39
吉他入門課程1 - 課程目標講解與示範 - 藝術蒲公英計畫by artscharity11,604 views
- 26:39
Hadoop Basics for SQL Server DBAsby BrentOzar1,852 views
- 49:57
How to Build an iPhone App that Doesn't Suckby StanfordUniversity98,694 views
- 10:52
Use Process Explorer and Task Manager to identify performance issuesby DefconComputers12,869 views
- 1:10:06
Microsoft SQL Server 2008 - Extract data from the cube by Amit Bansalby MicrosoftIndiaVideos3,137 views
- 29:51
SQL Server Certificationsby BrentOzar921 views
- 5:56
SQL Server 2008 Databases - Transaction Log [Video - 22]by tutorialjunkyard3,087 views
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!
utubesqueeze 3 months ago