On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is a little rough on this one because I used a new wireless microphone and forgot to put the wind shield on it.

If you’d like to watch the spatial video version on an Apple Vision Pro or Meta Quest, download this 2GB video directly – YouTube doesn’t seem to support MV-HEVC video just yet. If you’re on an AVP, go to that URL, then when the video starts to play, click Stop. (Safari doesn’t play spatial videos yet.) Click the Share button up by the URL, then choose Save to Files, and save it locally on the AVP’s file system. (Don’t save it to your iCloud Drive – you don’t wanna bother taking up space.) After it saves, then go into Files, find the video file, and play it from there. Sound convoluted? It absolutely is! I look forward to YouTube (or Vimeo or someone) supporting MV-HEVC uploads, and Safari supporting MV-HEVC playback. Sharing & playing spatial video in Feb 2024 blows.

Here’s what we discussed:

• 00:00 Start
• 00:41 Artyom: Hi, Brent! We currently have a huge corporate dwh (100+ db, ~50TB in size) with mainly olap workload (reports, analytical ad-hoc). Queries are suffering from latches (pagelatch_up/sh) in tempdb. Any advice on what to try? Can it be tuned or do we need better hardware?
• 01:53 MyTeaGotCold: How can I test something under the same load as Production? My test server is identical, but I don’t know how to give it identical burdens.
• 04:31 Q-Ent: Hello Brent. I see that most of advises around SQL server performance tuning are related to SELECT and rarely on DML queries. Is this because they follow the same logic or we don’t have a chance for better performance?
• 05:57 tominyorks: Have you ever seen Query Store and Optimize for ad-hoc cause an extreme increase in log growth? Using Erin Stellato’s suggested defaults for QS settings, I saw log sizes grow up to 2000% and backups take 200 times longer so now I’m trying to figure out out to use fn_dump_dblog
• 07:24 ChompingBits: My friend has a 6TB Data Warehouse running OLA scripts on Indexes and Statistics weekly Saturday. They run from a CAS for multithreading, but run until Wed/Thu. Any advice to speed up processing? The server is almost a whole VMWare host worth of resources, so that’s out.
• 09:31 RollbackIsSingleThreaded : Hi Brent! Does disabling lock escalation on a table reduce blocking during concurrent bulk inserts?
• 10:42 Sophie M: What is your opinion of Microsoft Fabric certification? Worth it?
• 11:18 Frozt: Have you ever conduct a Daily Standup for Production DBA? I feel like my new manager wants me to micro my team but we are already functioning automatically and not sure what is the purpose of this. He/she wants to build camaraderie but is this micromanagement?
• 12:20 Rom: What is your opinion of optimized locking in Azure SQL DB? Will we see this feature flow down to boxed SQL?