IBM has a Redbook out called Database Performance Tuning on AIX, which is pretty database agnostic and covers all sorts of different databases, although oddly enough, not SQLServer. :-)