And all this advice just points out how difficult it is to provide a good answer to such vague & general questions.

I hope all this helps. You've received great pointers.

Jonathan's advice here [/url]would still be completely applicable to virtual machines, whether they're running in the cloud or not.

Last batch means the last time it was run, not the amount of time it's been running.

It's the checkpoint operation. That's a fundamental part of the process. It's actually what...

The time it takes really depends on the system you're installing it to, the stuff you choose to install, the size of your databases, a ton of stuff that I...

Not sure about the encryption. I'm not sure why that would affect performance much at all (a little in the CPU I suppose).

As to figuring out how the server is...

Yes, you can upgrade from Standard to Enterprise. You just have to purchase an Enterprise license and then install the correct software.

That's an internal process. It's not the cause of your issue. I'd suggest you look for blocked or blocking processes or non-system processes. Also, generally, I don't suggest using sp_who...

What? On how to upgrade? You get the software for SQL Server and you start clicking Next, Next, Finish. Here's a Microsoft lesson plan that walks you through a lab...

Everything Gail said, plus, remember it does capture the values in microseconds. Just change the display to use those instead of milliseconds and you'll see fewer issues.

GilaMonster (5/7/2014)

And you've been denying for months that you...

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