• Since there is 24 GB of memory, and the DB is only 8 GB -- and, I am seeing really fast response time on the disk, I think it cannot be the disk, even if it wasn't configured optimally, after the 2nd execution of the same query, most of the IO should be coming from memory cache, not disk.

    I tried setting the maxdop down to 4, and changing it to 0, it is still slow on the delivery of the data either way.

    I am starting to think this has something to do with the memory, that either it is terribly slow, that something is incompatible, or that something is wrong with it. The kernel being so hard hitting on the one processor, and the hardware interrupts being high on that proc make me think it may in fact be a hardware issue.

    I'll be having them put CU5 on tonight and see how it goes from there.

    I am also going to get a trace to see if everything appears to have slow delivery, or if it just things over a certain amount of reads, or if just looking at the trace results I get a new idea about what is going on.

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