On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from 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. For the spatial video version for Apple Vision Pro and Meta Quest, 2GB: downloads.brentozar.com/spati...
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?
22 май 2024
