My first thought is that something is not right at the source!

😎

Question; have you analysed the offending queries?

Quick comment: NO LOCK == NO LUCK

😎

Has your doctor ever asked you how many painkillers you are taking in order to diagnose your problem?

Quick question; why store the Excel files as BLOB?

😎

There are several resilient options for file storage, most of which will provide better visibility/usability of the content.

There are a few possible causes, we need some further information!

😎

Quick questions:

1. was this Error 684 and Severity 22?
2. Could you please post the output of "SELECT @@VERSION;"
3. Can you...

Can you share some more details, don't like guesswork?

😎

Quick question, is the application's query interface a predefined API or dynamically constructed SQL?

😎

Capturing the queries on the server comes with a considerable overhead, I suggest you do an impact...

What is the problem you are trying to solve?

😎

First of all, establish what the issues are and then target those issues! Without a proper RCA (Root Cause Analysis), I will not provide any guesswork on a possible solution.

😎

Another...

Piling on Jeff's solid advice, the term "throttle" can have different meanings! My perception is that the requirements are not clear enough!

😎

Far too often, throttling is thought of as a...

Quick Question, do you have clear RPO and RTO?

😎

Without those, designing a DR solution will be a futile exercise!

Johan has a good point, just as Orwell stated, not all "versions"...

First thought, check if security and permissions for the Agents Service account are identical on all instances.

😎

A solid advice from Lovell as usual!

😎

I have used the backup method many times with only a few minutes of downtime, even on relatively slow connections. Suggest that you script...

Quick question, what are the recovery mode and backup details?

😎

Recursion is notoriously slow for iteration.  Maybe use a "standard" tally table instead:

;WITH
cte_tally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cte_tally100 AS (
...