Posted by dunleav1 on 09/28/96 11:58

Two more things

What is considered to be a high number of stolen pages?
I am geting about 10000 on average during a test run.

I have configured the sql server to have 2048M of memory but the task
manager only shows 1700M allocated to sql sever. If sql server needs
more memory because of stolen pages why isn't sql server grabbing more
than 1700M of memory.

The server has 4G of RAM and a 4G swap file.

• Next in forum: Re: Flattening Parent Child, an issue, please help
• Prev in forum: Re: sql server i/o bottle neck ?
• Thread view: Re: sql server i/o bottle neck ?

[Reply to this message]