• Yes exactly its a contention on my datafile SGAM pages

    But not in tempdb its on user db.

    How I do this in prod.

    Dividing into equal no of files and into different file groups if possible.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]