I absolutely love Extended Events.

However, for SQL Server 2008R2, I don't recommend you use them. They were a 1.0 release then and the functionality just wasn't quite up to snuff....

You could look at transactional replication. Since you're not talking about multi-way replication, you shouldn't need to modify the existing data structure to make it work. You'd only need to...

A manual script shouldn't take hours for that amount of data. I'd investigate exactly how it's doing what it's doing.

Regardless, another vote for Data Masker. Although I do work...

Availability groups should, under most circumstances, operate within 20 seconds. It's that or transactional replication. No other choices at all.

It really does depend on the two tools we're talking about and why you're using two.

Now, take something like Microsoft System Center as a monitoring tool. It does the bare...

A key lookup occurs when the cardinality estimator does not have a better index than the primary key to use in the query plan.

The solution to this is to...

When handed a system, before anything else, backups. I don't care how fast or slow the system is, if the backups aren't good, all bets are off.

Once that's in place,...

Yes. You can. Just remember, what you want to run are trace events. The Profiler tool is just for consuming the data generated.

However, I'd be remiss if I didn't point...

I'll be honest, I'm not even going to try to propose a solution to the query. Sorry.

Instead, let me ask a question. Have you looked at using a columnstore index?...

SQL Server will always use as much memory as it can. You may want to adjust or even disable that alert. You could be getting a lot of false positives...

Also worth noting, modifying two tables within a transaction can be a vector towards deadlocks if another procedure or query modifies the same two tables, but in a different order.

Agreed. You can run it as a push or a pull. It'll be the same. Probably, just as a general precaution, I'd run it as a pull, scheduling it from...

The differences in load is likely the differences in behavior (not necessarily, but, you know how it goes). Those settings were just a couple of examples. I'd examine both sets...

OK. Most of the work then is going to be with the structures you're building. It's a good idea to know that there are system views (frequently called tables) that...

I'm not familiar with the app, so no help there.

When you say you don't see it in your QA environment, my inclination would be to first ask what differences are...