@CraigYes there is scenario where local physical tables were creating and dropping in the user database not in temp db.There are lot waits with wait types pagelatch_upand the wait resource is 5:1:3(db_id:FG:pageid)page id 3 is SGAM I went through most of the stuff including adding files and enabling trace flag 1118 globally.I do not want move files to other drives because all of them are raid 5 dri