https://www.sqlservercentral.com/Forums/Topic1804884-3411-1.aspx
SQL performs disk IO in extents and an extent is 8 pages, each of which are 8KB, for a total of 64KB
[SQL Server]改善I/O效能- NTFS Allocation Unit Size(4KB vs 64KB)
https://dotblogs.com.tw/stanley14/2016/09/18/063116
[SQL Server][裝機]:格式化資料磁碟,使用 64 KB 的 NTFS 配置單位大小(allocation unit size)
http://sharedderrick.blogspot.tw/2017/05/sql-server-64-kb-ntfs-allocation-unit.html
Understanding Pages and Extents
https://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx
Disk Partition Alignment Best Practices for SQL Server
https://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx
Introduction to Page and Extent in Sql Server
http://sqlhints.com/tag/pages-from-uniform-extent-in-sql-server-2016/
沒有留言:
張貼留言