Take the 2-minute tour ×  A friend of mine asked me today
(trying to calm down an agitated customer of his) how you could
find out in SQL Server 2005 which database uses how much memory
(in the server's RAM that is) at any given time.  Is that
possible at all? If so - how? Can you do this with built-in SQL
Server tools, or do you need extra third-party options?  His
customer was all flustered because his dedicated SQL Server
machine suddenly uses all but 200KB of its 4 GB of RAM. I don't
think this is a problem, really - but since this guy claims it
happened more or less over night, he wants to know what caused
this increase in memory usage.....   share|improve this question
2 Answers 2  up vote 24 down vote accepted  It was most likely
caused by a query wanting to read more pages into the buffer
pool, and the buffer pool grabbing more memory to accomodate
that. This is how SQL Server is supposed to work. If the box
experiences memory pressure, it will ask SQL Server to give up
some memory, which it will do.