title: SQL Resource Waits - Buffer I/O - PAGEIOLATCH_SH
body: <p>I am not a DBA, but have recently been charged with monitoring my companies DB.  A merge that normally takes 12-18 minutes is now taking over 2 hours.  This was setup by a DBA and I am told that all the indexing was done correctly.  I found in the activity monitor that the process is hitting a PAGEIOLATCH_SH/EX wait type and the Resource Waits - Buffer I/O wait times are above 3000 (I cant find a baseline to see if this is normal...but it doesn't seem to be).  Does anyone have any information on where I could go from here?  I have already tried restarting the SQL server and force re-compiling the stored procedure that calls the merge. We are not working with an massive DB only about 2 million rows or so.   </p>