Assessing and Optimize Enterprise SQL Server Environments
summary
Enterprise assessment shows a few small targets deliver big wins: top 1% of code = >50% cost across servers, so tuning a single hot query that runs millions of times can cut yearly spend from ~$110,000 to ~$1,000; consolidating copies and junk tables saves license and storage costs (example: DBA utility collecting perf data back to 2006 consumed 500 vCPUs); concrete actions include msdb index fixes, non‑prod rightsizing, data lifecycle automation and index consolidation that yielded ~45% runtime improvement. convert CPU to $ to sell to business
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
43mPerformance Tuning, Getting the Biggest Bang for Your Buck
57mYour Performance Tuning Check List
44mTidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers
26mThe five-step guide to SQL tuning
47mArchitecting for High Performance SQL Server on Virtual Machines- 44mTidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers