Can you upgrade 2008 to 2008R2? Yes, absolutely. There may be licensing costs involved. You'll need to contact Microsoft to see what the situation with your license may be.

Well, if you want to use this generated job you'll need to get SSIS on it.

So that error is pretty straight forward. You have the wrong version of the SSIS service running on the system. You'll need to fix that.

Yep. It's on the chopping block. They've discouraged people from using it for over a year and now they've cut it from the product. Suggestions are that there may be...

jcrawf02 (5/7/2014)

ChrisM@Work (5/7/2014)

I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should...

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...