SSD newbie here. Already posted one question in a thread. Now I have a new question.
Is it a bad idea to use a SSD for a database server, purely based on the technology (ignoring cost as I am assuming over time it will level out at a reasonable price point)?
Uptime and reliability would obviously be important. But if performance was phenomenally increased, I don't see why a good backup regimen to mitigate chances of a catastrophic loss wouldn't be sufficient.
I ask the question in case the technology and usage itself would basically cause you to burn through an SSD in a week, so to say. Or lose data at a significantly higher frequency than a mechanical drive.
Again, I am taking cost out of the equation.
Thanks!
Is it a bad idea to use a SSD for a database server, purely based on the technology (ignoring cost as I am assuming over time it will level out at a reasonable price point)?
Uptime and reliability would obviously be important. But if performance was phenomenally increased, I don't see why a good backup regimen to mitigate chances of a catastrophic loss wouldn't be sufficient.
I ask the question in case the technology and usage itself would basically cause you to burn through an SSD in a week, so to say. Or lose data at a significantly higher frequency than a mechanical drive.
Again, I am taking cost out of the equation.
Thanks!