What version of LANDesk are you running? I had similar problems when we were on 8.7, but after upgrading to 8.8 haven't noticed any issues at all. Prior to upgrading, I did try installing ldms_status from droppedpackets located here:
While I still noticed the database errors, it seemed to bring the service back online most of the time.
We are using LDMS 8.7 SP5. The installation of this Core server was done in late Janurary, and the SP5 patch was applied at the time of installation.
Please note: The patch should resolve the issues you are seeing with the Service Crashing with Out of Memory errors. But it will not address the issues what the column width is too short these will continue until you extend the column specified to accomodate your scan data I.E:
First error: "the size of AppSoftwareSuites.PRODUCTID is too small, increase its size by at least 10."
To resolve these open the Database in Ent Manager or Management Studio
Backup the Database
Open the table properties and extend the length of the PRODUCTID field.