First a quick question, why the dirty read (READ UNCOMMITTED)?

Without more information such as execution plans, view code, schema structure etc., it is hard to tell what the problem is.

😎