• I recommend using Page Faults (not a SQL Server specific indicator) to indicate when the memory is falling to the page/swap file as your indicator. There's usually a little traffic there even under no pressure so you'll want to check your system for tolerance levels while it's running 'cleanly'.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA