I have a 4G Ram computer with SQL Server 2000, Standard Edition.
Although, memory used by all application is around 2G, some counters suggests the memory is not well managed:
- SQL:BufferManager:FreePages sits down 500 pretty often.
- SQL Server : BufferManage
age reads/sec goes over 200 constantly, it reaches 1000 from time to time.
ages/sec goes over 50 constantly.
- PhysicalDisk: %Disk Time goes over 55% constantly; it reaches 600-700% oftenly.
The same server is used for:
- few databases “small enough” 1-2G each
- file server
- printing some stuff
I’m suspecting file server is the one which harms the computer, but I don’t know how to get this proof.
What should I do next? Any idea is welcomed.
Thanks in advance.