Thank you Grant Fritchey!

I don't have Web Service RDS, but I ran below SQL Statement on local SQL Server  and got information as the file.

SELECT dl.deadlockgraph

FROM

(

SELECT dl.query('.') AS deadlockgraph

FROM...

Saw that. Fixed it.

I'd say that REORGANIZE is unlikely to because it touches so few pages normally when it changes indexes. A REBUILD on the other hand, that might do it. I only...

1. For deadlocks you can look into the system_health Extended Event session to find more occurrences. I have an example query here on this blog post on AWS RDS....

The only real way to improve "move all the data, all at once, right now" style queries is spending money. Buy bigger, better, faster, more hardware. That's the answer. Or,...

So, let's be clear up front, I work for Redgate Software and we make a tool that competes with Foglight, so you can take that into account with what I'm...

Run DBCC checks on your system databases. It sounds like either one of them is corrupt, or you're hitting an issue with tempdb, as was suggested in the error message...

Also, look for hidden issues like triggers.

You can look at execution plans for INSERT/UPDATE/DELETE queries, same as for a SELECT query. Common issues affecting performance can include stuff like foreign...

I'm not that familiar with MySQL, so I can't say how it works. However, I can talk to SQL Server. The key here is that first column. There are two...

The statistics went out of date and need to be updated. As was already stated, the data changed, the statistics changed, a new threshold was reached, and when the plan...

Total agreement with Jeff & Brian.

I will say though, to a degree, and there are hundreds of caveats to this, what makes a good index in one RDBMS, roughly translates...

Just and idea for the future. To be helpful to others, go ahead and leave the question up, but supply the answer too. That way, the next person who hits...

Is this person in way over their head?  It seems like he was dumped in a closet and given orders to find out everything.  He's been pretty prolific with...

All you can do with the information you have is infer the schedule and plan. That's it. You can't know what the intent is. You can't know what the Service...

You're approaching it all in the perfect manner. 1) find solutions to the problems at hand 2) use those solutions as a way to improve your skills.

Keep going. Don't hesitate...