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

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.
主站蜘蛛池模板: 习水县| 麦盖提县| 霞浦县| 固原市| 松滋市| 卢氏县| 安溪县| 浦北县| 合江县| 屏南县| 汾西县| 四子王旗| 山西省| 沧源| 郁南县| 临海市| 和平区| 志丹县| 江津市| 永福县| 萝北县| 台中县| 泰宁县| 时尚| 淮北市| 济源市| 禄劝| 兴化市| 巩义市| 绵阳市| 富平县| 方山县| 瑞金市| 会同县| 江山市| 中阳县| 阳城县| 咸宁市| 瑞丽市| 甘泉县| 大关县|