GilaMonster (4/19/2013)
McSQL (4/19/2013)
Start with the missing indexes...You can't add indexes to a sharepoint content database without losing all support.
Really, I didn't know that. As soon as I created the missing indexes the I/O dropped from 50% to 7%. Maybe I need to look
at SharePoint documentation instead of just SQL.