all read committed. i fixed the issue with a query rewrite and a new index. thanks for the reply though