Hard to say. Most likely it's some sort of resource contention, blocking, something along those lines. But I'm just guessing. We don't have enough data.

It looks like a series of problems, but I can't see the complete error messages. I'd suggest modifying the jobs so that they output everything to a file so you...

You'll need to reexamine your plans. Federation has been cut from the product. It's not off all the data centers yet, but it will be. You'll need to shard manually...

So, it's probably a rounding error. The capture of events in trace is in microseconds. Your display is milliseconds.

Yeah, pretty much. You just need to know that it has failed over and that it's back online. No other special monitoring needed.

The same ones you'd monitor on any other server. The only real addition is that if some event causes a failover, your monitoring needs to be able to capture the...

All the errors you're listing are just the symptoms from the allocation errors. They're not going to help you troubleshooting the origin of the problem. Instead, you need to look...

Check the ANSI connection settings for each environment. If they're different it can lead to different execution plans and therefore radically different performance.

What do you mean by "-ve"?

And you're right, a negative duration is not really possible. The actual capture of trace events is in microseconds and the GUI in Profiler displays...

No. You won't be able to do that. Some of the functionality of Enterprise is in those system tables. You'll have to migrate security or SQL Agent jobs using export...

Those are going to run directly in sequence, not in parallel.

You need to set up a service on a separate server to monitor your servers. That service can then send emails. You can do this through SQL Server, code, or...

Then, basic understanding of concepts. JOINs, WHERE criteria, fundamentals on relational storage. Nothing hard really. Primarily, I'd explore his knowledge set, not actually test it. He's not in a position...

It sounds like you have to processes trying to do the same thing. You can't rebuild multiple indexes simultaneously on the same table.

To see other processes as they're running use...

I'm with everyone else. I wouldn't suggest waiting for SPs at this point. There have just been fewer and fewer of them. I suspect they may be going the way...