• Old Box (SQL 2000, Windows 2003)

    Table 'foo', Scan count 1, logical reads, 6346, physical reads 0, read-ahead reads 0.

    New Box (SQL 2008, Windows 2008 R2)

    Table 'foo', Scan count 1, logical reads 3940, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

    So the new box does something close to 1/2 the qty of reads, yet it takes 10X as long to display the results, even locally.

    There is nothing else on this server, no AV, no IIS, no services, firewall is off. Nothing showing up in Task Mgr as being out of line. I'm just stumped. There isn't even much running at all.

    Mindy Curnutt
    Sr. SQL Server DBA / Hardware Infrastructure Architect
    TMW Systems, Inc.
    twitter: @sqlgirl