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

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.
主站蜘蛛池模板: 定南县| 峡江县| 钟祥市| 白玉县| 南漳县| 淮南市| 宜兴市| 北京市| 盐亭县| 浦城县| 张北县| 囊谦县| 玉溪市| 灌阳县| 逊克县| 奉节县| 尖扎县| 南乐县| 油尖旺区| 八宿县| 涿鹿县| 余江县| 拉孜县| 曲阳县| 抚州市| 萍乡市| 太康县| 正定县| 滁州市| 沅陵县| 十堰市| 四子王旗| 东光县| 扎鲁特旗| 铜鼓县| 江城| 普陀区| 凤阳县| 澎湖县| 祁阳县| 盘锦市|