Just read an interesting article on AV and SQL by Michael K. Campbell - short, but gets to the point. It has a link to a very useful Microsoft KB article on AV DLLs that cause SQL performance issues.
Friday, 27 December 2013
Thursday, 19 December 2013
Solaris - /tmp permissions
Had a bit of a problem when one of the guys decided to restore file to the /tmp directory instead of the original location.
The ownership changed on /tmp to the restored folders owner which had a knock on effect with some scripts.
To fix the problem the following commands were applied:
# chmod 1777 /tmp
# chown root:root /tmp
The ownership changed on /tmp to the restored folders owner which had a knock on effect with some scripts.
To fix the problem the following commands were applied:
# chmod 1777 /tmp
# chown root:root /tmp
Monday, 16 December 2013
Solaris - ZFS quota
Setting up a ZFS quota:
1. Create mount point
# zfs create -o mountpoint=/mp rpool/mp
2. Set a 5Gb quota
# zfs set quota=5G rpool/mp
The mount is now created with a quota.
What happens if you now want to increase the quota?
Increasing the quota to 20Gb
# zfs set quota=20G rpool/mp
At some point you may want to get rid of the mount point and its quota
# zfs destroy rpool/mp
1. Create mount point
# zfs create -o mountpoint=/mp rpool/mp
2. Set a 5Gb quota
# zfs set quota=5G rpool/mp
The mount is now created with a quota.
What happens if you now want to increase the quota?
Increasing the quota to 20Gb
# zfs set quota=20G rpool/mp
At some point you may want to get rid of the mount point and its quota
# zfs destroy rpool/mp
Subscribe to:
Posts (Atom)