• I noticed when I first opened the tool that the INS1 page splits ratio to batch requests was running close to 20%, pushing the limits for my preferences, although it dropped back to about 10% after I started going back to check on it.

    I normally have several more memory counters, too. I am guessing that you don't look at Page Lookups/sec because you have close to zero adhoc access to the data and are not worried about poorly performing queries?

    Pages Reads/sec and writes/sec not being used because you know that your indexing is already as good as it can be? (or plenty of memory?)

    It's a nice tool, though.

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems