On October 15, 2019, Per Christopher held a webinar for the DBA Fundamentals virtual group in PASS about managing large database server farms. He compares how going from a small family farm to a large industrial farm compares to going from a handful of SQL servers to large database server farms, and looks at how you will need to update your mindset and tool set as the farms grows:
Managing: SQL Server farm management vs single instance management
Most DBA’s are cowboys, but there is much to learn from the world of cow hearing and dairy farms that can make us manage SQL Server instances in a better way. SQL Server farms are the future of large scale database management, and we will teach you the ropes. Introducing the FarmQueryLanguage brings another dimension of control to large scale management.
Managing large database farms requires a different mind-set and a different set of tools than what you need when you only have a handful of instances to look after.
He discusses in-depth the new challenges that managing a large farm brings on, from the way you think (see the forest, not just the trees) to how you change your focus from instance-centric performance and health to farm-centric resource management.
Per Christopher Undheim is a Senior DBA at dbWatch AS, a Norwegian software company which develops a software solution for database operations. He has over 15 years of experience in different aspects of database management on Oracle and Microsoft SQL Server platforms.