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

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

That's going to be tough. We have to define what you mean by "most common" because it's very function dependent. Are you developing a database for an organization? Then the...

Great to see all the hams.73 to you all

This fight, like so many others, does come down to ignorance. We have to constantly educate ourselves and others.

Trace can do pretty much all you're looking for. It's just going to put a much heavier load on the system while it collects the data. Also, it's horrific at...

You're going to blow it out of the park Brandie. Relax and have fun with it.

Sorry, I'm confused. "update stats on the table with...