• Not enough information to say anything useful.

    What were the specs of the old server. What OS, what version of SQL?

    What are the specs of the new server. What OS, what version of SQL?

    What's the max memory setting on the new server? What's the max degree of parallelism set to on the new server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass