Before doing this, make sure you're giving enough memory to the instance to
accommodate your needs. Your instance may be ballooning just because it needs
that much to be healthy, especially since you have 19 databases on that
system. Check your page life expectancy and watch for recompiling stored
procedures that SHOULDN'T recompile. If you starve your instance just to save
memory for the host, you'll kill performance by recompiling SPs too often, or
reading from disk and writing back to it too often.
Matt Ungaro
Network/Storage & Oracle Operations Analyst, SCP OCA
Capitol Indemnity Corporation
-----Original Message-----
From: Eisbrener John
[mailto:mssqldba-ezmlmshield-x80104937.[Email address protected]
Sent: Thursday, September 27, 2007 8:24 AM
To: LazyDBA Discussion
Subject: RE: Memory usge.
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
---------------------------------------------------------------------
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