You've described the scenario, but I don't see much in the way of solutions. Do you have a question? If not, expand this out, provide some solutions, and submit it...

Not a clue. I haven't seen something like this before. However, I'd suggest not bothering to look at the proc cache any more. Look elsewhere. What the heck is using...

There's a login event that will let you know when a login has been completed. You can also look for login errors. Here's an article on the concept. Here's...

You could try forcing the processing over to the remote server through OPENQUERY so that filtering is done there. Otherwise, the way your code is written, yep, it's moving everything...

Do you have monitoring in place to understand why the CPU is maxing out? Without more data, I'd just be guessing.

Strictly talking INSERT, and nothing else. Assuming the data being inserted is coming from an identical structure. That structure does, in fact, have foreign keys in place. Those keys are...

Pretty sure the answer to using the Microsoft backups is that your choices are:

• Portal
• Powershell
• Azure CLI
• REST API

That's per the documentation.

The issue is simple, that stuff is...

OMG. I'm so sorry. Deleting my responses. Reading is fundamental and I have failed.

You can use Extended Events to capture the statements executed. If I was doing this one, I would capture rpc_staring, sp_statement_completed and rpc_completed. All three filtered to the object id...

Just my 2ct: did you try to checkpoint all databases before running the backup ?

btw: We mostly produce local backup files and only copy those afterward to a safe...

<deleted>

• This reply was modified 1 years ago by Grant Fritchey.

Well, doesn't sound ideal then. Still, might be worth a test.

Something entirely different to look at would be to add the use of a columnstore index. Those things are specifically built to work with analytical style queries like this. You...

<deleted>

• This reply was modified 1 years ago by Grant Fritchey.

Interviewing for open position...

My boss: Rate your SQL skills & knowledge on a scale of 1 to 10.

Interviewee: 7 or 8

Me: Let's talk about backups and restores.

Interviewee: I have...