Assessing and Optimize Enterprise SQL Server Environments
summary
Claims that the top 1% equals 50% of database cost guide a concrete plan: identify the same expensive statement running across hundreds of databases, quantify its dollar cost, and tune it once to multiply savings. A deployed tool (Fortified Insights / Wisdom) maps on‑prem servers to cloud costs, surfaces top statements, and shows per‑query annual dollars. Concrete wins include consolidating 30 indexes to one for a reverse‑logistics report (runtime down 45%), removing a DBA utility table that consumed ~500 vCPUs, and enforcing data lifecycle and cost of code rules like compression, msdb indexing, and smaller non‑prod sizes.
AI-written summary · about
chapters (25)
- 0:00Enterprise SQL optimization intro
- 1:55Pareto principle for data platforms
- 3:01Innovation vs budget balance
- 6:15Cost impact of initial design
- 8:48Tech costs in business terms
- 9:52Top 10 queries optimization
- 11:37Runaway DBA utility DBs
- 14:07Low-risk config tweaks
- 17:00Cleaning redundant DB artifacts
- 18:25Data lifecycle management
- 19:52Fixing missing/excess indexes
- 22:01Non-prod env cost reduction
- 23:25Cost of code over time
- 24:26Fortified Wisdom cost demo
- 27:58Prioritize by financial impact
- 30:28True cost of data storage
- 33:21Avoid data hoarding
- 35:31Enterprise data strategy
- 36:32Reduce duplicate DB copies
- 37:59Reporting optimization wins
- 40:34Missing data strategy risks
- 41:381% rule for cost cuts
- 43:05Shift to cost efficiency
- 44:33Enforce dev cost budgets
- 45:38Q&A on platform cost
related talks
49mAssessing and Optimize Enterprise SQL Server Environments- 49mAssessing and Optimize Enterprise SQL Server Environments
44mTidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers- 44mTidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers
18mHow to reduce your SQL Database costs on Azure
26mThe five-step guide to SQL tuning
43mPerformance Tuning, Getting the Biggest Bang for Your Buck
52mMore for less: Cost optimizing your Azure SQL databases