Except almost nobody buys them, even last years for 10 bucks each. That's almost useless ECC Reg memory for HPE Gen 8 servers and workstations (from before late 2015 / start of 2016 with the introduction of the Gen9 using DDR4).
ECC unbuffered DIMMs (9 memory chips per side, no reg buffer/controller) is less available, quite widely used on level entry systems and thus costs a lot more even second hand.
Yep. Don't expect to sell those sticks on ebay at great price. Those new chips will be likely soldered to appliances like low end routers/APs, set top boxes, various adapters, low end systems, PLCs, IPBX, NVRs and various embedded devices.
I sold 7,2 Kg of DDR1/2/3 sticks two month ago, for gold recovery. As well as expansion cards, hdd PCBs and a few other things. Got about $600 from this.
West EU here, bought a new, architecturally wrong (yikes) house in 2012. I knew its conception would spell trouble, and sadly I was not disappointed on this part almost right off the bat. But the location and the price (right on the aftermath of the 2008 financial crisis and economical fallout / market bottom) were good.
After 14 years it cost an average of $130 per month on maintenance, mainly to correct on multiple occasion the conception issues aformentioned after the 10y warranty. Utilities are about $170 per month. And taxes are now about $1700 per year (rise 3-4% every year)
This $250k purchase must have cost less than $2k in fees, the credit was... well no credit. Spent almost 100% of my savings except some cash for my business. On the overall this house cost me less than $500 per month so far. Not really surprising for a new house, certainly.
And its market value rose by 60% in 14 years.
Yep, ownership is (was ?) very profitable in the west EU, mind the location.
Well, SAS disk tend to go in failed state immediately or very quickly, most of the time without going first through the warning state.
SATA disk are indeed generally more predictable failure-wise. Most issues are related to a failing head stack assembly. Rarely platter demagnetization for some disks (Toshiba laptop).
Other failure issues are usually related to a friggin' manufactured firmware issue from Dell, HP or Lenovo corp.
Hi,
I believe you are quite new to workstation/hardware admin. Lots of things to say here (not native english speaking so basic style, sorry for that) :
A disk error of this type showing in the event log must immediately be treated as an actual disk issue. This is a low level issue below the actual filesystem and application/services. Seems here the .mdf/ldf of your SQL database used one or more bad sectors on the disk surface.
Your disk seems to be only one on the system, so the first thing to do is check SMART status, for example with Crystaldiskinfo (the most used and user-friendly free portable windows software).
It would very probably have shown a warning state for the internal disk, with probably one or more (judging the quantity of disk error entries in your log) for Attribute C5 "Current Pending sectors" and probably some in Att 05 - "Reallocated sectors count" and/or Att C4 - "Realloc event Count".
Second thing to do is trying to backup your data as fast as possible.
In your case related to a Ms SQL database, trying to dump it / backup first was the good move. Sadly (DR pro experience here), weak surface / failing Head Stack Assembly of a traditionnal HDD from most vendors has more difficulties reading correctly a sector than writing it.
If the dump/backup fails, the second choice would have be to try to a sector-to-sector dump approach of the whole disk, with either a online (from OS) software capable of reading sectors from the boot disk (didn't try if HDD Raw Copy Tool 2.6 supports it), or an offline solution like Clonezilla, Acronis True Image, Aomei backupper, etc. But offline solution means offline computer and service...
I didn't exactly understood if you had an actual backup of the data or an image of the whole disk. Considering the critical usage of this station, you should have both running : daily data backup or more + up-to-date disk image ready. whatever the type of disk (HDD/SSD). And a spare, identical computer.
As for repair of HDDs "weak sectors" (meaning Current Pending Sectors), it is indeed possible, often with complete data recovery. If not, the sector will be left as is, or may be remapped if written to 0 (it will then shift from Current pending to realloc sector count).
Hard disk Sentinel Pro as such features (Disk repair, Quick Fix), it works quite well. The result vary greatly from one type of failure to another, as from one disk maker to another.
Note that if the SMART shows more than a little dozen of sectors, the head (amp/preamp) is probably failing, making weaker magnetically-wise sectors too difficult to read and/or write. In this case, the count of current and remapped increases every repair/check pass made by the tools. In this case, the drive is toast and must be replaced ASAP.
SSD are a complete different case for repair.
A older autonomous tool, Spinrite, was specialized for this usage (accurate recovery of data), but veeeeery slow.
RAID pertinence : fortunately, it is an expecteed case as most SATA disks are prone to HSA failure before not initialyzing at all. A RAID 1 mirror would have protected you from a mirrored defect accross the two disks.
The RAID controller (true hardware controller like LSI/Avago or Microsemi) or even fake raid like Intel RST / VROC maintain data integrity accross the array's disks. The defective disk will raise bad blocks (that will get marked in metadata of the Raid Volume), but the others disks are fine and the data can be read safely. If too many errors are reported on a disk (very few in fact on most controllers), it will be labelled as failed and taken down from the array.
Except I'm no maker. I'm in a midlife crisis stuck between two opposing forces : the urge to make something of my life against the risk of putting too much time and efforts to ultimately fail plus the futility of it all. Virtually wealthy enough not to work a day anymore now with my current lifestyle (aside the risk this EU country's state defaults and falls).
Quite a perfect neutralization scheme in this "hunt for self-actualisation".
That's why the display of commitment shown in this thread hurts.
Arrr. Here's the monthly dose of low self-esteem for all those who struggle to get anything worthwhile done. Currently working on figuring how you get motivated and competent enough as I browse various link from this thread.
Agreed, the first gen MX500 with M3CR023 fw proved IMHO to be the second most reliable SATA SSD 2.5" form factor with the Samsung 860 range SSDs (860 Evo / Pro).
Sadly, the MX500 is now difficult to find in western europe. Only lower grade BX500, still quite reliable but not as fast as the MX500 with cache + DRAM.
Had quite a lot of controller issues (become sluggish for periods of time) with the sandisk/WD ones like green/blue and SSD plus.
Very sad news.
Crucial Micron is (soon "was") an great brand for computer assembly and upgrade. It is sad to see the brand rushing to the "easy money" stream. This won't be forgotten when the current bubble will evenually pop and they might meet the same fate as the now forgotten Elpida (who bought Qimonda wich also failed).
The MX500 1st gen (fw M3CR023) was the second best SATA SSD range with the kings the Samsung 860 Evo and Pro. P3 and P3+ were very good drives with great princing for some time, not comparable to the Samsung 970 Evo and Evo+ though.
Never had a failure on about 500 units of crucial MX300/500/P1/P3/P3+/P5. Always updated their firmwares, though.
Comparatively, had lot of sluggish controllers on Sandisk/WD green/blue SATA SSD, and some BX500. But a lot better than any entry level generic Phison S3111 based SSD.
Also very few failures with DDR3/4 DIMMs and SODIMMs. Less than with Kinston and Corsair modules. About the same as Samsung OEM modules from HP/Dell.
Now let's just hope Samsung will not follow in their tracks. I don't see WD-Sandisk going corporate only since they do not make DRAMs modules.
Have seen hundred of chinese ones fail. More than half failed between 1 and 3 years.
As stated by others, issues are mainly and very commonly with the power stage / power management of the mainboard. Also, soldering quality issues leading to failures.
Far less issues with good brands like Dell and HP (had a few hundred of desktop mini g2/3/4). Even tinys from Lenovo do perform quite well compared to their entry level laptops (also quite bad). Industrial computers form factor are also generally quite good but quite expensive, even second hand ones.
Currently don't have enough feddback on the Asus ones nor enough volume to draw conclusions, but so far they performed well with minimal issue, even with models back from i3/i5 8th gen series.
The inf update indeed almost didn't do anything beside renaming lots of PCI 8086:xxxx peripherals and I/O spaces.
To really wreak havoc, play a bit with Intel Dynamic Platform & Thermal Framework Chipset Participant on 6th/7th gen CPU, by installing optional drivers updates pushed by Windows 10's WU on many laptops (like HP's probook).
I believe the Oracle 8 SQL Server we used at school in the starting of the '2000 was running on a RS/6000 system on AIX.
Nice system, had a good memory from it performance-wise. MySQL was not a serious competitor at that time.
The machine had often overheating issues starting from the beginning of june when ambiant temp rose above 24/25°. We did not have CVAC in the building.
Chuckles.
Intel and AMD provide ME/AMT/SPS and PSP respectively on their whole x86-64 CPU range, which are embedded SOC : a CPU (based on quark for intel) and basic OS (said to be from Minix 3 for intel as well), nested within the CPU in the way they cannot be disabled as they are serialized to logical CPU init, "microcode style". Add obfuscated code modules, cannot be completely removed whatever everyone could do up to now. It can access to the network stack and has an "always on" behavior once the system is simply plugged to the power.
If you're security concerned, the OS stack is quite a... secondary issue to you.
You will have to consider switching to an open RISC architecture (Risc-V someone ? Strangely enough or not, EU seems quite fan of this on-the-rise-again architecture) AND a linux distribution.
For sure, for sensitive applications, having a cheap, secure and versatile architecture would be better than making DSPs or issuing hardly scalable and pricy FPGA solutions (well, lots of communication equipements' mainboards still uses them)