I noticed that SPIDS were being killed on a regular basis although the timing was Intermittent. There appears a record in the SQL Server errorlog which reads as follows: Process ID 121 was killed by hostname xxxxx-SPOTL-APP, host process ID 0.

After some…

The better a problem is described, the better the assistance tends to be.
(*Note: Please refrain from including private data in your posts)

Consider and include the following information in your initial post:

• Product, Version, and relevant environment…