Re: Allocating memory

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike Hodgson (mike.hodgson_at_mallesons.nospam.com)
Date: 02/28/05 

Date: Tue, 01 Mar 2005 10:44:24 +1100

According to SQL BOL, the "min server memory" and "max server memory"
sp_configure settings *do not* require a restart in order to take affect
(see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_3wmr.asp).
These are the 2 settings you'll need to change to set a fixed memory
size for SQL server. 

--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@mallesons.nospam.com |* W* http://www.mallesons.com
David C wrote:
>If I want to change SQL Server to use a fixed memory size, do I have to 
>stop/start SQL Server...or even the whole server to do so?  Thanks.
>
>David 
>
>
>  
>

Relevant Pages

  • Re: How to Set Datetime on SQL 2000 server
    ... I ran Query Analyzer on the SQL Enterprise Manager and ran: ... Windows 2000 server and the test 2003 server actually use US date format, ... regional settings, since you now are dependent on that as well. ...
    (microsoft.public.sqlserver.setup)
  • Re: Seems like only 1GB RAM being used even when higher MAX RAM is
    ... Did you look to see what Task manager shows the other 1GB being used for? ... Are their any other apps running on this server? ... Andrew J. Kelly SQL MVP ... sp_configure 'max server memory', 2147483647 ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2000 slowness
    ... things you can do to help narrow down the issues, ... I'd check the SQL Service Packs first. ... Check your server settings (make sure your settings for memory usage, ...
    (microsoft.public.sqlserver.programming)
  • Re: How to Set Datetime on SQL 2000 server
    ... I checked the regional settings in Control Panel. ... the current user account and to default user profile" under the Advanced tag. ... I may need a reboot to re-fresh this setting in the whole server. ... I don't know how to change the logon language for a SQL server account. ...
    (microsoft.public.sqlserver.setup)
  • RE: Memory configuration for Win2k3 and SQL2k
    ... > Max server memory should be set to the max memory you want to dedicate to SQL Server. ... > To prevent page file fragmentation, it is recommended that you set the paging file size initial and maximum values to be the same value. ...
    (microsoft.public.sqlserver.clustering)