For example can we monitor for DIMM failures.
Yes, if you have the vendor MIBS or can obtain them you can use the snmptd probe to monitor for DIMM failures.
snmptd IM configuration