A. OLTP database generally have a large number of random write, it is recommended to choose RAID 10 to store data.
B. In order to improve write performance, all SQL server database data stored in the LUN write strategy is configured to "write back the image".
C. Because the size of the SQL server page is 8K, in order to ensure the best performance of the database, NTFS allocated block size should not be less than 8KB.
D. SQL Server database instance memory size and recovery mode of choice has no effect on the performance of the database.