What budget ssd will go for an underserver in the office?

Question

Solid State Drives

Hello. We are assembling a computer for an accountant in the office, which will work as a sub-server. That is, it will have an accounting database, an accountant will work behind it, and other devices will connect to this computer over the network in order to gain access to the database. There is also a possibility that sometimes the computer may not turn off at night and work for 70 hours

. Working with the disk itself involves accessing both many small files and files weighing 15GB each, where the task of the program is to find a certain line in the file. One file - many lines.

Here is your choice:

TRANSCEND TS256GMTE110S 256GB pci-e
SILICON POWER M-Series SP256GBP34A60M28 256GB pci-e
TRANSCEND TS256GSSD230S 256GB sata 2.5
WD Blue WDS250G2B0B 250GB sata m2
KINGSTON A2000 SA2000M8 / 250G 250GB-e pci
CRUCIAL MX500 CT250MX500SSD4 m2 250GB sata
A-DATA XPG SX6000 Pro ASX6000PNP 256GT-C-e-256GB pci
WD Blue 2.5 WDS250G2B0A 250GB sata
INTEL 545s Series SSDSCKKW256G8X1 m2 256GB sata
WD Blue SN550 WDS250G2B0C 250GB pci- e
INTEL 545s Series SSDSCKKW256G8X1 256GB sata m2

Which is better?

And the question, among other things: m2 sata and sata 2.5 - apart from the connectors, do they differ in something else? There is wd blue and crucial in both versions. Which one is better to take?

Motherboard supports nvme x4

Answer 1

For the voiced tasks - any.
Essentially you need an office computer for an accountant - so any SSD.

m2 sata and sata 2.5 - apart from connectors, do they differ in something else?

No.
SATA is a protocol for data transfer. And what kind of connector you will use to connect to the SATA controller does not matter.

Motherboard supports nvme x4

So you can use drives running on the NVMe protocol, it is better than SATA, created specifically for SSDs. Such drives are connected either directly to the PCI-e slot, or through various M.2 or U.2 connectors.
For the tasks voiced, there is no particular difference between NVMe and SATA. In practice, you probably won't notice. But NVMe is a more modern and SSD-friendly protocol.
Are you sure that you have enough disk space for 250GB?
SSD should not be hammered to the eyeballs, otherwise there is no point in it.
Therefore, take it so that in any situation there is at least 50GB of free space.
And one more thing - if the network load is large, there will be a lot of reading and writing, and performance is critical, then the database should not be placed on the system disk.

Answer 2

I would take
https://www.dns-shop.ru/catalog/dd58148920724e77/s...
Backups:
https://www.veeam.com/ru/windows-endpoint-server-b...

Answer 3

m2 sata and sata 2.5 differ only in that the first one has one connector less, respectively, one point of failure, and the slot version is more reliable than a cheap cable
one. Better, of course, to take NVME, since the mother holds it. And by choice, well, in the i-market, compare and choose the one with the best parameters for the wallet

Answer 4

SATA SSDs in M.2 and 2.5 "differ only in the connector.
What exactly to take - look at the reviews and personal preferences. Better than PCIe, they are much faster.
For SSDs, I highly recommend setting up status monitoring, for example, through smatrmontools. As a rule, there is a parameter showing the use or balance of spare sectors and the consumption or predicted balance of the SSD resource.Well
, backups are a must.Unlike HDDs, which most often die gradually accumulating bad sectors, SSDs can die instantly without the ability to quickly restore data.