Home Forums SQL Server 2008 SQL Server 2008 Administration No performance gain on queries on different servers with considerable hardware change RE: No performance gain on queries on different servers with considerable hardware change

  • Hi,

    Interesting.

    It may be your log file? Is it on same or different RAID and on what type? It's recommended to be on separate and faster disks.

    It may be your tempdb? It also should reside on faster disks.

    It may be the disks. Are the allocation units sizes same?

    It may be the server settings?

    You can make a check for these stuff.

    Regards,

    Igormi

    Igor Micev,My blog: www.igormicev.com