官术网_书友最值得收藏!

Planning disk capacity

No simple formula exists to calculate disk capacity. We can just estimate the amount of disk space needed from similar applications or from older databases. Disk space needs described on MSDN are sufficient for empty SQL Server installation, not for production environment.

When preparing disks, we have to consider the following points:

  • Using directly attached disks is very common approach. Only possible issue is that the server itself does not have a sufficient number of controllers and disks don't have enough space for large scale real-world production databases.
  • The best way is to use SAN storage, which has a sufficient number of controllers and allows you to spread every database across more disks.
  • Let its own disk be present for the tempdb database; this database is used internally by SQL Server as well as explicitly by developers as an optimization helper for complicated queries (however this is not best practice).
  • If the server has a low amount of memory (less than 64 GB) and more memory is needed especially for read-intensive OLTP databases, the administrator can set up a buffer pool extension (BPE). It is a file supplying more memory area for so called clean pages. SQL Server enhances the buffer cache and stores data pages intended to be read only from database to this file. The best practice is to place the BPE on its own SSD disk.
  • Data files and log files of databases should always be separate. SQL Server uses write-ahead logging. This means that SQL Server caches data from data files and, at the moment, describes to the transaction log file what will be done with the data. When data and log files are not separate, overhead could occur on the disk controller.
主站蜘蛛池模板: 剑河县| 赣州市| 本溪市| 肇州县| 平远县| 天镇县| 晴隆县| 卢氏县| 武安市| 彭山县| 延安市| 桓台县| 报价| 安化县| 寻甸| 平舆县| 麦盖提县| 南漳县| 新晃| 天祝| 鄂尔多斯市| 犍为县| 正宁县| 浏阳市| 宁陕县| 宣化县| 黄骅市| 翁牛特旗| 宁德市| 原平市| 白山市| 萝北县| 仪征市| 嫩江县| 沧州市| 宜良县| 南雄市| 茌平县| 章丘市| 西青区| 张掖市|