Re: how to configure SQL Server 7.x memory

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 03/08/04 

Date: Mon, 8 Mar 2004 08:13:10 -0800

Geoff,

Thank you for the quick response. Does this mean you do
not have to run sp_configure "Memory" (similar command as
in sybase) to fix a set amt of memory if it is less than 4
gb in size?

Thanks
Cynthia
>-----Original Message-----
>Until you reach 4GB of physical RAM, PAE and AWE are
unnecessary settings.
>Normally, SQL will adjust itself to take all memory and
leave 8-10MB free.
>This is good if the server is dedicated to SQL. If other
applications run
>on SQL, you may want to limit how much memory SQL uses.
That can be a trial
>and error process since the memory consumption depends on
the behavior of
>other applications.
>
>So, if it is a dedicated SQL server, leave it alone.
Once the OS sees the
>memory, SQL will take advantage of it.
>
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>
>I support the Professional Association for SQL Server
>www.sqlpass.org
>
>"Cynthia" <anonymous@discussions.microsoft.com> wrote in
message
>news:940601c40525$32a37b00$a101280a@phx.gbl...
>> Hi,
>>
>> I am curious what the steps are to follow to configure
the
>> SQL server memory settings please?
>> How do you tell what the current setting is?
>> We have 500 MB of RAM and an additional 500 MB of RAM
was
>> added. How do you give more memory to SQL server?
>>
>> In previous posts that I have scanned for memory in
here,
>> what is awe?
>>
>> Thanks,
>> Cynthia
>>
>> (only temporarily assisting to optimize the SQL Server,
as
>> I am not a SQL Server DBA..any help is appreciated).
>>
>
>
>.
>

Relevant Pages

  • Re: How much memory(RAM) required for OS running Oracle
    ... OS and rest of memory for Database and for system with>16GB we ... Oracle installation and allocate remaining memory for Database (SGA + ... applications, options and configurations. ... I think some docs about PGA settings may be misleading (or at least ...
    (comp.databases.oracle.server)
  • 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: Proper SQL Server Setup and Excessive Paging
    ... > Max Server Memory: 29764 MB. ... > SQL Server Configuration settings: ... > Possible problem with setup: ... > I setup a dedicated SQL Server with one 35 GB production database that has ...
    (microsoft.public.sqlserver.setup)