This is a 32-bit Windows 2003 Enterprise server having 4GB RAM.Earlier we had enabled the /3GB switch on it to allow user processes including SQL to consume upto 3GB memory.But then we ran into memory leak issues arising out of older bios drivers and other stuff.Microsoft gave us some action items among which one was to remove this /3GB switch.

So now we are back to a 2GB user memory and I have to monitor the SQL memory consumption over the next few weeks to see if it is running fine under this limit or if it needs more memory.This is why I need to automate this memory monitoring process.

Now can you suggest something more substantial than a max memory setting?