-- SQL 2005 memory (x64) --

Hi,

I have a windows 2003 server enterprise edition x64 w/SP2 and MS SQL Server 2005 x64 Enterprise Edition (1 instance).

I have a server IBM w/6GB in RAM. The task manager shows only 4GB of available memory but 6GB of physical memory. In the MS SQL Server properties / Memory / Maximum server memory it allows using only 2GB. I have not activated AWE options because I understand that 64 bits architecture doesn't need it to work with more than 4GB. Please see images attached.

What I want to do is to assign 4GB of RAM to SQL Server and 2GB for the OS. I'm not sure if it's the best configuration (5GB and 1GB probably is better). I have a RAID5 for the data files of the SQL Server and I've being thinking to use 4GB of cache in this RAID (I don't know if this is a good idea) for better performance.

I appreciate your comments regarding this matter.

Edmundo J. Davila

Attachment: Memory.doc
Description: MS-Word document

Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Consolidating instances of SQL server
    ... SQL Server is designed to use memory. ... The maximum amount of memory SQL Server can use varies depending on your ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Benchmark for different edition SQL 2000
    ... Please read the links I posted about memory allocation algorithms in SQL Server. ... My concern is how to prevent the SQL server that increase the memory usage continuously? ... Enterprise edition has some distinct features that SE doesn't. ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)
  • RE: The DBMS returned an unspecified error.
    ... | We are using Microsoft's JDBC driver for Java database access to SQL ... | Insufficient memory available. ... even though SQL Server 2000 is configured to use up to the ... the problem is most likely in the MemToLeave ...
    (microsoft.public.sqlserver.jdbcdriver)
Loading