Extend, Expand or Resize an LVM root partition ‘/’ in linux

If your linux root partition ‘/’ is an LVM, you could easily extend the drive. Make use of the commands listed later in this post.

First let me explain how an LVM is setup.

Different components in an LVM setup
Physical Volumes These are real physical hard drives or partitions attached to the machine.Favorite commands: pvdisplay, pvcreate, pvresize
Volume Groups Several physical volumes are combined to form a volume group. Multiple Volume groups are also possible. Additional PVs are added to a VG to expand it anytime online.Favorite commands: vgdisplay, vgextend, vgcreate
Logical Volumes  Logical Volumes are carved out of a Volume Group. Logical Volumes could be expanded anytime if its VG has enough free space availableFavorite commands: lvdisplay, lvextend, lvcreate

In short, several physical volumes(PV) are first created. Volume groups(VG) are then built on top of multiple PVs. Logical Volumes(LV) are then carved out of any VG until the VGs run out of storage. Adding more PVs to a VG would help increase the storage in the VG.

Now lets get to work. Continue reading.

Continue reading “Extend, Expand or Resize an LVM root partition ‘/’ in linux”

SQL Server 2012 Daily Health Check

Being a DBA, it is good to have some kind of automated health check report that gets delivered to inbox with quick glance of DB health. Hence this script will be very useful. Copy this script and schedule as a SQL agent job. Provide the mail profile and recipient addresses. The script was built with help from several colleagues and references from different SQL forums.

Continue reading to view and copy the script. Since the script is too long, it could not be posted in homepage.
Continue reading “SQL Server 2012 Daily Health Check”