I have a XEON CPU from the same time, and have no problems with SSD's.
Any SATA SSD should be good (non M.2), try top stick to known brands, e.g. take the
Samsung MZ-76Q2T0BW
Your Motherboard only has SATA 2, so you will be only getting around 300MB/s, but it will still be faster than most harddrives, especionally when it comes to random access.
You could install yourself something like this: https://www.amazon.de/Richer-R-Controllerkarte-Erweiterung-Windows7-Server2003-default/dp/B07D6GB9M3/ref=sr_1_15?keywords=PCIe+auf+SAta&link_code=qs&qid=1573918066&sourceid=Mozilla-search&sr=8-15
if you have PCIe Slots left, to fully profit from the Speed, a SSD will give you.
JH17002723 got a reaction from Windows95 in can I install an SSD on my 10yo computer?