Yup, and hence Test Manager and RAMMap are both lying to you. Neither considers physically allocated memory (what locked pages allows SQL to take), and hence they're both showing 24GB...

Honestly, part of the problem here is that you're looking at disparate things and assuming they mean what you think they mean, when they probably don't.

I don't have time to...

Don't guess. Diagnose and identify the exact problem. Guessing just wastes time.

Problem is by pulling the DB out of the AG, you'll have lost any information that was in AG-related...

Just saw that. :angry:

Prefixing objects with their schema is a good thing to do and is a recommended practice. Not doing so can cause problems with plan reuse. It's something I flag as...

Try

CONVERT(bigint, IIF(IsNumeric(CALL_ANI)=1,CALL_ANI, CAST(0 AS bigint))) AS ANI

Then the log backups are not the issue. The issue is that something else is preventing log reuse. Switching to simple will do exactly the same as a log backup...

Precon tomorrow. Two presentations at SQL Sat on Saturday. Usergroup meeting on Tuesday. Flying to Cape Town on Friday, 1 (or maybe 2) presentations on the Saturday. Grad on the...

Per user.

It's the sameish as a web server connecting to SQL and people using the web site. The people using the site need to be licensed, not the web server.

Don't. Use. The. Task. Manager. To. Check. SQL. Server's. Memory!

The task manager does not show accurate values in several cases. Do not use it. Use perfmon and look at the...

http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Switching to simple recovery will only do anything if the cause of the logs not truncating was the lack of a log backup. If that was the cause, then doing...

You haven't got lock escalation. If you had, it'd be a LCK_M_S at the table level, not the intent lock.

The only thing that would be blocking an intent S lock...

That won't do anything. The SELECT...

It wouldn't, though identifying cores/NUMA node might be a tad more challenging, and if the VM admin's screwed up the config, could be harder still.

Remove the limited autogrowth, you mean?

I would...