I am still not sure what the killer app was for the Alpha. Other than OpenVMS/Alpha to provide the business continuity for existing VMS customers, DEC was not really all that successful with the Alpha from that perspective.
Yes, Windows NT Alpha did take off initially and was the go-to non-Intel platform for CPU hungry apps, but it was expensive and then Intel caught up with multi-processor Pentium Pro systems and that was the end of the Alpha.
Sun SPARC/UltraSPARC was effectively a hardware appliance to run the Oracle database (and SAP). SGI/MIPS covered the 3D graphics market. IBM POWER was the hardware to run DB2 and other IBM wares ported from mainframes for customers who did not want to have to deal with JCL and other hairy stuff. HP PA-RISC was an enigma that ran something although not that many people were sure what exactly it was. HP Superdome was pretty rad tho – I worked on a project for a telco that had purchased a 128 CPU Superdome to run their billing system on (ironically, it was IBM who had sold them on the Superdome). HP-UX before v11.21 had been buggy AF and overall an abomination.
Yes, Alpha could run Oracle as well, plus other things… they never seem to have taken off tho, and Alpha was quickly relegated to an IP garage sale.
From the technology perspective, Alpha was a resounding success, at least in the beginning.