SQL Server & memory

Last Post 28 Feb 2007 12:28 PM by ranejeb. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ranejeb
New Member
New Member

--
28 Feb 2007 11:07 AM
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 : BufferManageage reads/sec goes over 200 constantly, it reaches 1000 from time to time.
- Memoryages/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.
ranejeb
New Member
New Member

--
28 Feb 2007 12:28 PM
Here are some graphs.

Isn't possible to use 3G with Standard Edition?
SQLUSA
New Member
New Member

--
06 Mar 2007 01:58 AM
Agreed. "Iron" is dirt cheap. Get a dedicated server for SQL Server 2000.

Kalman Toth
SQLUSA: http://www.sqlusa.com
You are not authorized to post a reply.

Acceptable Use Policy