That's partially true. SQL Server starts occupying more memory as when
the processes need memory. If you set the min memory size to 500 MB, it
would not start occupying 500 MB immediately, but once it reaches 500 MB
it may not release the memory depending on your memory setting.

Jitendra, How much memory do you have in this server? You can try
setting a fixed amount of memory for SQL Server (if you haven't done it
already). As Greg pointed out you can do this using Enterprise Manager,
right click the server and use Properties -> Memory.

For more info, look at his KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363


John

-----Original Message-----
From: Greg [mailto:[Email Address Removed]
Sent: Wednesday, August 27, 2003 8:01 AM
To: LazyDBA.com Discussion
Subject: RE: SQL Server is taking too much of memory, in GB........

Sql Server, by default, will use as much memory as is available. You
can adjust this using the enterpise manager (right-click the server,
select properties, select the memory tab) or sp_configure.

-Greg


-----Original Message-----
From: Jitendra.[Email Address Removed] [mailto:Jitendra.[Email Address Removed] Wednesday, August 27, 2003 8:42 AM
To: LazyDBA.com Discussion
Subject: SQL Server is taking too much of memory, in GB........



Dear All,


I have migrated my application & Database from old server to high end
server. But in new server I am having one problem. My SQL Server is
taking
very memory usage. It starts around 25-30 MB Memory & goes upto 1.8 1.9
GB
Memory. I really don't know why this should happen.


Regards,




Jitendra Pratap Hadap






---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page