Hello! In your opinion, what is the best file system to run a server database ASA9 in linux?
What should I consider to make the most agile possible?
Thank you.
While generic test comparison results may be useful as a "rough guide", it's important to remember that no matter which performance test result you may see, it's not representative of your workload for your data on your server hardware (and even more specifically for filesystems, on your media device).
Hence, the most accurate answer is to compare the filesystem timings for yourself on a representative performance test.
To best determine your hardware
information you have to create a
performance test that mimics your
production workload. This performance
test should control as many different
performance factors in the database
server as possible, while modifying an
individual server factor in a set of
tests to establish its effects on your
overall throughput. Once you have
gathered this information (after
varying things like the server cache
size, number of worker threads,
optimal levels of intra-query
parallelism, etc.) you can then use
statistical analysis to figure out
which performance factors are the most
important for your workload.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.