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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MS Sql Server LazyDBA home page