I have set up a new server and the sqlservr.exe process is only using 200 meg
of memory instead of the usual 1.5 gig on a 32 bit server with 2 gigs of ram.

I have tried to overide the memory settings with the min and max settings,
but the amount the process uses does not change.

What is going wrong on this system?

Don't use task manager to view the memory usage, use perfmon instead. SQL
Server Memory: Total & Target counters. But sql server will only use what
it needs. If it doesn't need more than 200 mbs then it wont take it. The
Min will keep it from falling below that once it reaches it, it does not
start there. The max prevents it from using more than that for the buffer
pool.


--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Greg" <Greg (AT) discussions (DOT) microsoft.com> wrote