Every time a Cognos8 Report was executed, a critical application would freeze. And even when the report had finished I still needed to go into SQL Management Studio and kill the blocking Cognos SPID.
Eventually I found that the solution was to change the isolation-level used my the Cognos OLE DB connector from read-committed to read-uncommitted.
Database Consultant 