Managing and optimizing multi-terabyte databases presents unique challenges that demand a deep understanding of infrastructure, data architecture, and SQL Server internals. In this full-day session, we’ll walk through a real-world case study of a massive SQL Server database stored in a single file and filegroup, and the journey to transform it into a high-performance, scalable system.

Attendees will learn how to:

-Identify and resolve performance bottlenecks in large-scale databases.
-Design and implement effective filegroup and partitioning strategies.
-Optimize data types and storage to reduce size and improve throughput.
-Measure and benchmark disk and query performance using tools like diskspd and Crystal Disk Mark.
-Apply compression techniques and index strategies to maximize efficiency.
-Reconfigure infrastructure for better I/O, including SAN, RAID, and VM considerations.

This session is packed with practical scripts, performance metrics, and before-and-after results. Whether you're a DBA, developer, or architect, you’ll leave with actionable strategies to dramatically improve the performance and manageability of your largest databases.