Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SQLServerCentral Best Practices Clinic: Part 1 Expand / Collapse
Author
Message
Posted Wednesday, May 11, 2011 7:57 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654
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
Post #1106955
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse