Thank you for clarifying. That makes more sense to me.

Sometimes this stuff can get very confusing.....

Mike

I guess I'm not understanding the comment(s) about why to use sockets instead of cores. Is it something like this:

1 socket 8 vCPUs is the same as 8...

Kevin,

Thank you for the response and information. I do have a few follow-up comments and questions.

There is a VERY good reason to not split tempdb...

Thanks for the info.

You're correct--I have done an in-place upgrade. Why would you avoid this? If I uninstall and re-install, I'll need to configure the entire instance again...

Thanks, everyone, for the replies. This wouldn't be a headache for us database developers and admins if apps would just construct their queries to leverage the query engine instead of...

Tim,

That makes a lot of sense. I never considered that SSIS was using its own memory allocation, though it is a separate application altogether so it also makes...

Thank you!

Does anyone know the answer to any or all of my follow-up questions? I've googled most of this, but I would just like confirmation if you know the answer(s).