{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Tech Sessions","title":"Ep. 8: Maximizing Efficiency: Cost Optimization through SQL Server Re-architecture on Google Cloud","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/d8481728\"></iframe>","width":"100%","height":180,"duration":2551,"description":"In this episode of the Tech Sessions podcast, host Jeff Dickman sits down with Roy Douber, Senior Director of DevOps and Architecture at e360, to discuss SQL migrations, cost optimization, and performance improvements through SQL Server re-architecture on Google Cloud. Discover how e360 tackles large-scale SQL environments to deliver significant cost savings and enhanced performance for their clients.\nTopics Covered:\nInitial challenges and state analysis of the client's SQL environment\nImplementing failover clustering and automation for improved performance\nAchieving significant cost savings and operational efficiencies\n\nKey Takeaways:\nThe importance of a thorough financial analysis alongside performance testing in SQL re-architecture projects\nHow failover clustering can reduce costs and improve disaster recovery capabilities\nThe role of automation in minimizing operational toil and ensuring consistency\nInsights into selecting the right storage solutions and configurations for high-performance SQL services\nPro tips for architects and engineers on testing, automation, and adaptability\n\nMentions & References:\ne360 services: www.e360.com\ne360 Pulse on LinkedIn\nTech Sessions on YouTube\nTime Stamps with Highlights:\n[00:00:00] Introduction: Jeff Dickman and Roy Douber discuss the episode's focus on SQL migrations and cost efficiencies.\n[00:01:37] Initial Challenges: Addressing a large, difficult-to-manage SQL footprint.\n[00:04:22] SQL Optimization: Strategies to handle noisy client issues and improve performance.\n[00:07:00] Solution Overview: Implementing failover clustering for cost-effective, high-availability SQL services.\n[00:11:57] Storage Solutions: Ensuring high IOPS for SQL services with advanced storage technologies.\n[00:14:10] Financial Analysis: The critical role of financial planning in SQL re-architecture projects.\n[00:16:22] Cost Savings: Achieving $30 million in savings over five years through optimized SQL architecture.\n[00:18:53] Operational...","thumbnail_url":"https://img.transistorcdn.com/w96k2aMTS9rIUgIBPgkP3q1GQskJCotv1LAzHUdRB_g/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9jNjI1/YzBmYjY3NmVkZWY4/ZTVkOWQ3M2JkNTA1/ZWRmYy5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}