Database applications are one of the important applications supporting storage arrays. Different application configurations and parameter settings may affect the service performance. In order to store arrays (such as OceanStor V3 series storage) with SQL server applications with the best performance, which of the following statements is wrong:
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.
Correct Answer:
Verified
Q408: Which Huawei oceanstro V3 storage system prefetch
Q409: In OceanStoe VIS6600T delivery scenarios, multiple vendors
Q410: In the OceanStor VIS6600T dual-redundant switch network
Q411: According to the backup plan, the storage
Q412: VMware cluster high availability technology enables proxies
Q414: There are multiple types of disks in
Q415: For commonly used SQL Server 2005 and
Q416: When designing SQL server database disaster recovery,
Q417: Which backup agents in WMware VADP Data
Q418: In dual active disaster recovery solution architectures,
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents