In Enterprise Studio (SQL 2000 or SQL 2005), right-click on the server name,
click properties, click memory tab, enter in the maximum amount of memory you
would like your SQL Server Service to use. I would recommend you restart the
service to ensure the setting is working to your satisfaction.
John Eisbrener
SQL Database Administrator
Capitol Insurance Companies
-----Original Message-----
From: Hannes Coetzee
[mailto:mssqldba-ezmlmshield-x94469686.[Email address protected]
Sent: Thursday, September 27, 2007 2:11 AM
To: LazyDBA Discussion
Subject: RE: Memory usge.
Hi Gents
Thanks for the help. I did what you said by checking the mem usage
column and that shows that sqlsrvr is using most of the memory. Any way
I can free up some memory?
Hannes
-----Original Message-----
From: Rick Romack
[mailto:mssqldba-ezmlmshield-x99298670.[Email address protected]
Sent: 26 September 2007 11:58 PM
To: LazyDBA Discussion
Subject: RE: Memory usge.
Neal,
SQL 2005 ignores the minimum memory setting. The only memory setting it
uses is the maximum. I would use task manager and Click on the Process
Tab and then the Mem Usage column. This would show you the process that
is using memory.
Rick Romack
-----Original Message-----
From: Neal Sivley
[mailto:mssqldba-ezmlmshield-x46639619.[Email address protected]
Sent: Wednesday, September 26, 2007 2:43 PM
To: LazyDBA Discussion
Subject: RE: Memory usge.
Well, you have to check and see how your memory is configured on the SQL
server. If you are using fixed memory then SQL will ALWAYS take the
allocated memory. That doesn't mean that it is using it all, it just
hordes it so that no other program can use it that way when it needs it,
it is already available.
Thanks,
Neal
-----Original Message-----
From: Hannes Coetzee
[mailto:mssqldba-ezmlmshield-x52701325.[Email address protected]
Sent: Wednesday, September 26, 2007 3:05 PM
To: LazyDBA Discussion
Subject: Memory usge.
Good evening all.
I have a Win2003 Ent Server (x64) with SQL2005 Ent (x64) running on Quad
Core Intel with 8 gig memory. 19 SQL Databases on the server.
Problem is. When I restart Sql, the memory usage increases to nearly
'full' within 2 minutes. I cant restart SQL every 10 minutes to free
memory.
What can I do to check what is utilising the memory?
Regards
Hannes
This message is subject to the disclaimer found at
http://www.macsteel.co.za/emaildisclaimer.jsp
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
________________________________________________________________________
_____
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com
________________________________________________________________________
_____
________________________________________________________________________
_____
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com
________________________________________________________________________
_____
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message from State Compensation Insurance Fund and all
attachments transmitted with it may be privileged or confidential and
protected from disclosure. If you are not the intended recipient, you
are hereby notified that any dissemination, distribution, copying, or
taking any action based on it is strictly prohibited and may have legal
consequences. If you have received this e-mail in error, please notify
the sender by reply e-mail and destroy the original message and all
copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message is subject to the disclaimer found at
http://www.macsteel.co.za/emaildisclaimer.jsp
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page