Database applications are one of the important applications supporting storage arrays. Storage arrays, operating systems

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Database applications are one of the important applications supporting storage arrays. Storage arrays, operating systems

Post by answerhappygod »

Database applications are one of the important applications supporting storage arrays. Storage arrays, operating systems, file systems, and database application systems, etc.
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 application with the best performance, which of the following statement 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply