I get the same error.

2 Windows 2003 Servers running SQL Server 2005 and Red Gate's latest.

Researching now...

We were allowing some physical memory for the OS, just not much. And the OS can always use the spare virtual memory-- we have something like a 4 gig swap...

We ended up contacting Microsoft (phone) support about this issue.

We chatted with the technical router who took some rudimentary notes about our issue and determined that it was of a...

In case this helps, this is what appear to be some relevant (i.e. different) results from DBCC MEMORYSTATUS from yet another one of these incidents which lead to us restarting...

Here's an example of this happening. Here are the results from DBCC CACHESTATS and DBCC PROCCACHE, about 3 minutes apart. There was no blocking and low CPU usage before, and...

2. The lead blocker typically has no wait time. These are "rolling blocks"-- that is, they aren't blocked for very long. Compiling is a serialized deal, I think, and since it...

1. Since we originally implemented AWE (but no longer rely on that as far as a SQL Server setting is concerned) we did enable the SQL Server service to Lock...

I think the "MSI" stuff might related to installing programs (with the MSI installer). Usually after the installation it cleans these up automatically. Perhaps these are failed installations. Perhaps after...

I can easily understand the desire to have this metric. The number of lines of code-- for better or worse-- has long been used as a metric to gague the...

We establish the procedure cache is being cleared by querying sys.dm_exec_cached_plans, which when running well has a large number of records but when running poorly has nearly no records (we're...

This is still happening. Reboots and service restarts have not permanently solved the problem, though they generally help a lot for a while.

The backups no longer run during business hours.

We're at...

I guess I should have stated "and then the fun started". The backups no longer run during business hours yet the issues still happen. (They only ran during business hours...

The temp table is actually created outside the procedure, so it can't be a temp table variable. It would have to be a real table with some additional programming.

That said,...

Database Mail in 2005 is also very weak in formatting the results of a query sent via email. Basically, you get pure text only. If you want to actually transmit...

A number of SQL backup tool developers are saying this is pretty much just how it is.

We're proceeding with testing Replication for now.