• How does your disk configuration compare to the old box (i.e. what is the allocation unit size? Was the disk aligned on both servers?, raid configs? disk speed?)?

    What about the maxdop setting on the old server? Are all of the SQL configuration settings the same on both servers (except obvious things like memory increases for the new box)?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events