SQL Server Estate Management at 25,000 Databases: The Operations Manual Nobody Wrote
SQL Server Estate Management at 25,000 Databases: The Operations Manual Nobody Wrote I run 25,000 databases across more than 300 Azure VMs. I’m the only senior DBA. Most estate-management advice assumes you can name your instances from memory. That stops working somewhere around server forty. I stopped counting names years ago and started counting ratios instead. This post covers the operating model that keeps the estate alive. It isn’t a product pitch. Search for “SQL Server estate management” and you get wall-to-wall vendor pages: Redgate, Quest, Aireforge, IDERA. Every one of them sells a tool. Tools are fine, but tooling was never the bottleneck at this scale. ...