• Thanks Kevin.

    I will check it out.

    But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected by -T1222.

    Dirty Reads does not seem an issue, but they do not want to restrict the threads, since there are huge imports mostly.