Bump.

Curious if no one's responding because the request is not possible or because I'm not clear.

Here's what I ended up doing (in case someone finds this in a search).

I ended up repairing

Microsoft SQL Server 2008 R2 (64-bit)

in the

...

Available Physical Memory 523730944

System physical memory high 1

System physical memory low 0

I can't find Target Committed or Current Committed. I have

Committed 524288

Target 52428

That's a huge results set, anything specific that I should pull in or is the target and committed in here somewhere?

The output of that query shows 2,680. I don't know how to check the others.

Task manager shows that sqlservr.exe is currently consuming 4,266,016k on the "Processes" tab...

Actually, yes and no. I inherited this install without the password for the initial instance. I've since stopped the service (a long time ago) and am unable to...

I believe it's 64 bit (even though it seems to be installed in the 86 program files folder).

I followed this process for the lock pages in memory and...

When I run that code I get:

name__________________minimum_____maximum____config_value____run_value

max server memory (MB)____16______2147483647______4096_________4096

Yes, I'm using task manager. I'm not sure what the "buffer pool" is but what I do know is that if I do the following commands

NET STOP "SQL Server...

Grasshopper, it looks like that was the solution, thank you so much everyone!!!

What exactly should I look for? I right click 'Database Mail' and send a test email and it sends successfully.