3 votes

SQL Server database with 100 terabyte of data

Some things to think about with databases of this size: Backup/Restore operations are going to take some time. If you are planning to use native backups you might want to look at partitioning and ...
David Wiseman's user avatar
1 vote

Azure Disk performance optimizaton in SQL VM

Luckily there's a doc on this: Storage: Performance best practices for SQL Server on Azure VMs For production workloads, use the P30 and/or P40 disks for SQL Server data files to ensure caching ...
David Browne - Microsoft's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible