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

For you to have a lot of one thing that relates to one or more other things, you have to have a way to map between in them that allows...

Are there two different servers involved? Are you in a failover situation or something along those lines? It could be that it was failed over during that period.

In the overriding majority of cases, no, this is a serious waste of resources. Most queries will only ever reference the clustered index, especially if they need to get any...

Did you follow the link to the query I posted? It shows how to query the Dynamic Management Views that give you access to the plans in cache such as...

Oh, and one other idea, you might be able to retrieve a query you were working on from cache. I did this once and blogged about it here[/url]. There were...