You've given me a lot to look at. I'll do some more digging on Monday. The reason I considered memory pressure is because processes that used to finish quickly or...

I can understand tempdb getting to be bigger if certain queries are running, etc. Usually I see that in terms of disk space, not in memory consumption. However, given the...

I guess the best way to put it is that 3GB doesn't feel right. 25% of a servers memory allocated to tempdb seems out of the ordinary and is definitely...

The server is a database server and only a database server. Nothing else is running on the box. It has a total of 12GB of memory in it.

Like I...

Easier said than done. The majority of everything running on this database server are purchased products, not home grown that we could tweak if necessary.

Based on the first link, I'm put together this query:

SELECT R1.session_id,

R1.internal_objects_alloc_page_count

+ R2.task_internal_objects_alloc_page_count AS...

Correct. I'm referring to Buffer Pool Memory, not physical disk space.

It failed again yesterday late afternoon. Processor spiked and it was doing a dump. No incoming connections were allowed. We were hoping we could use the dedicated admin connection, but...

Unfortunately, I'm not sure it was physical memory that was the problem. The box has 32GB of RAM and at the time the issue arose, SQL Server was only using...

The tempdb is on the same partition as the other databases. It has about 70GB of free space when the service starts up. Tempdb ends up consuming much of that...

Here is what is in the error log a little before and during the error. I have no idea how to decipher it and it doesn't really point me in...

Yes it is 64 bit.

We generally have between 100-200 connections, sometimes in the 200s when in high use. I looked at the logs but didn't see anything that seemed very...

That's what I was afraid of. When you say the host, I'm assuming you mean the server that SQL Server is running on. If that's the case, it did get...

Perfect Lowell. That's exactly what I was looking for. I kept trying various things, but didn't think to fully qualify it.

Thanks,

Adam

Do you know if there are any performance benefits to having it run one way or another?