Premium Only Content
October 2019 - Using Columnstore indexes in AzureDevOps by Konstantin Kosinsky (@kkosinsky)
Abstract:
The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process, etc.
Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions of records and daily growth in 10s of millions, only a few minutes delay from operation store, sub-second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries.
Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. The session covers how to:
* partition columnstore indexes in a multitenant environment
* maintain columnstore indexes in case of updates and/or purge to keep segment elimination possible
* evolve database schema without downtimes and maintenance windows
* design to benefit from predicate and aggregation pushdown
* deal with edge case like ad-hoc queries for raw data and paging
* choose between CCI and NCCI based on usage patterns
About Konstantin:
Konstantin is an industry expert who loves optimizing the performance at least in 10x. More data - more fun.
Konstantin is a Principal Software Engineer at Azure DevOps Services, where he works on moving the Analytics for software engineering to a completely new level.
Konstantin was born and had been working in Ukraine for a long time, passionately sharing his knowledge with Ukrainian and other European data communities. Before joining Microsoft in 2012, he was a Data Platform MVP for many years.
-
18:12:15
LFA TV
1 day agoLFA TV CHRISTMAS EVE REPLAY
128K14 -
13:32
Scammer Payback
15 hours agoChanging the Scammer's Desktop Background to his Location
2.87K3 -
4:21
BIG NEM
17 hours agoNikola Tesla's Secret to Cultivating Creativity & Genius
1.49K1 -
15:03
The Anthony Rogers Show
1 day agoAnthony Rogers - Live at Cusumano's Pizza (Upstairs)
1.2K1 -
4:33:48
tacetmort3m
1 day ago🔴 LIVE - THE ZONE KEEPS PULLING ME BACK - STALKER 2 - PART 15
68K12 -
22:45
Brewzle
21 hours agoI Went Drinking In A Real Bourbon Castle
49K4 -
48:36
PMG
1 day ago $4.30 earned"Parkland Parent Speaks Out On Kamala Harris Using Victims"
40.1K12 -
4:06
The Lou Holtz Show
20 hours agoCoach Lou Holtz’s Heartfelt Christmas Message 🎄 | Family, Faith & Notre Dame Spirit 💚 #christmas
29.6K -
51:35
Dr Steve Turley
1 day ago $21.44 earnedROSEANNE BARR - Her Journey, TRUMP, and the MAGA GOLDEN AGE! [INTERVIEW]
64.1K54 -
57:38
The Tom Renz Show
18 hours agoMerry Christmas - The Tom Renz Show Christmas
98.7K17