To ensure that I'm not losing my mind, I created the above table in Excel and was able to create the line-chart I need in a few seconds, with minimal...

OK, that makes sense. I have this, so far:

The three departments are being shown as the Series, which is what I want.
However, I just can't seem to...

Hi
I am following a similar process. However, I don't want to do any aggregation, as per this part:

Values: Any Numeric (Metric) value such as Total Sales,...

For anyone else who experiences this specific error (Error: 18056, Severity: 20, State: 46), I managed to find the cause after lots of reading...

There was a rogue entry in the...

😛 Thanks, Kevin. I'm very grateful for the help you've given me so far, for free.

Perry - Yes, there's one index in particular that is suggested as 'missing', but the...

Sorry Kevin - there are no parameters in this query. There are hard-coded values - the query is the result of a particular BI reporting tool.

I've attached both execution plans...

On further inspection, it looks like the execution plans for the same query are different when run on the primary and secondary replica databases. So, I guess I can...

Perry - those links suggest that making the latest statistics available on a readable secondary (via the secondary replica creating and maintaining temporary statistics for secondary databases in tempdb) should...

Thanks very much, guys. I'll do some reading and testing over the next couple of days and will let you know how I get on.

Thanks very much for the helpful replies.

I've used SYS.DM_EXEC_SESSIONS to look for running sessions using a SERIALIZABLE isolation level and we have many. I've looked into the query text for...

The backups take a good couple of hours, as there are several 1TB+ databases on the instance. They backup to a local disk, across multiple backup files.

The process itself is...

Sorry, I should've mentioned that I cleared the wait stats prior to each run.

Here are the top 4 wait stats right after the process has finished...looks like I need to sort out the formatting...

PRODUCTION

Server A instance:

wait_typewait_time_spctrunning_pct

BACKUPBUFFER417962.2432.1932.19

CXPACKET380097.5 ...

The high level design has been scoped such that in the event that we move to DR, the (new) production environment will be in its own cluster ready to go....

Ah, sorry - we'll be using detach>attach.

Gah - multiple accounts! :rolleyes: