I am running into issue doing a insert into fact table. Essentially i can see that insert is done and i can query table by using nolock. But job keeps on running (insert done with in 40 min and job ran for 3 hours) and i can see tempdb read and write activities in resource monitor. There is no disk disk activity on datafiles or logfiles of database i am trying to insert. Is sql server trying to process foreign keys to table? since its fact table i have lot of dimension keys but i am not sure. Also there is no other process running on server at that time. Any help is appreciated.