Month January 2022

Linux: migrate storage with pvmove

1. Begin by pvcreate’ing the new disk. This is the disk from the new storage array to which we want to migrate to. # pvcreate /dev/mapper/mpathY 2. Now, add this disk into the data_vg Volume Group : # vgextend data_vg…

Read More

Systemd: automatically restart after failure

With systemd you can configure the service so that it automaticaly restarts the service in case the service crashes.It’s enough to add the “restart” option to the [service] stanza within the service systemd configuraiton file.See example below. Of course, you…

Read More

Clamav: limit memory usage

Once in a while the clamd process can get killed because of memory usage. It turns out it would always get killed when reloading the database after an update. This is due to the fact that during a database reload clamd will…

Read More

T-SQL: Jobs in suspended state

It is possible that sql jobs are “hanging” in a suspended state. The SQL statements below will give you an indication on what the job is waiting.The first SQL statement will create a small stored procedure in the master database,…

Read More