First, thanks for your responses. I'm going to read up on Blocking. One quick question though, can this affect performance on just 1 thread? Other connections work...

Nothing else requires a reset. It's really strange, it gets hung up on a "select * from tableXYZ" and there are only 5000 rows of data in it. ...