• Hello.

    Thank you, I appreciate the responses, although they don't really address my question.

    I'm not expecting to see the page file being used, as I don't believe there is any reason it would need to be used, but the way I would track this would be through perfmon, and the data I am seeing there looks to be quite different from my expectations.

    I really need to be able to produce data I can take to the person questioning this, which at the moment I really don't have and what I am seeing doesn't make any sense. Can anyone explain the results I'm getting, or point me in the direction of where I would look to produce evidence that SQL is not using the page file and that it is handling the current workload without issue?

    The problem is really that I can't pick and choose which results suit my expectations- if I'm going to say a particular counter shows there is no memory pressure, then I need to be able to explain why another seems to contradict this.

    Thanks.