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
_____________________________________________________________________________

MS Sql Server LazyDBA home page