We are definitely experiencing performance problems because the lack of memory for everything else on that box (backup, AV, etc.) causes the OS to page SQL Server out to disk...

I'll go check out your blog this evening, Colin. We've been wondering if we didn't need to back off the max memory even more.

I copied process explorer over to...

Backup Exec, missed that one.

Noel,

We aren't using any CLR routines or extended procs on that box. If anything it's under heavy load of ad hoc queries we are slowly getting cleaned up with stored...