SQL Server Performance

SQL Server & memory

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by uiranejeb, Feb 28, 2007.

  1. uiranejeb New Member

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

    the counter above of relevence above is Memory<img src='/community/emoticons/emotion-4.gif' alt=':p' />ages/sec<br /><br />ignore % Disk Time<br />it has no meaning in a server system (multiple SCSI/SAS drives)<br />despite what other people say,<br />they are basing their experience on a desktop with 1 IDE/SATA drive.<br /><br />SQL:BM:FreePages low just means you are using the full 2G (minus memtoleave) available in S2K Std Ed<br />unless you want to upgrade to Ent Ed, or S2K5, such is life<br /><br />so just chase down the source of Mem-&gt; page/sec<br />it should not be caused by SQL<br />so one of the other functions<br />I don't think file server ops should cause it<br />see if you can link it to printing
  3. uiranejeb New Member

    Here are some graphs. Any help is appreciated.

Share This Page