3
votes
Accepted
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
performance × 6352query-performance × 2091
sql-server × 2055
mysql × 1729
postgresql × 1297
optimization × 616
index × 606
postgresql-performance × 457
performance-tuning × 450
database-design × 342
execution-plan × 310
oracle × 296
sql-server-2012 × 274
innodb × 248
sql-server-2008-r2 × 218
sql-server-2008 × 207
join × 203
index-tuning × 195
sql-server-2014 × 168
sql-server-2016 × 166
t-sql × 151
mariadb × 134
sql-server-2005 × 110
mysql-5.5 × 104
memory × 99