You raise a good point about other things running on the server, and yes we do have SSAS -- but its usually idle when these problems occur. It only has...

Thanks Brian for the reply.

Is it possible to us the Query Store to historically identify Parallel plans or problematic Paralellel plans?

We use synonyms a lot between databases so we can keep the general functionality separate and give us lines of demarcation for all sorts of things including the...

• This reply was modified 5 years, 1 month ago by  alex.sqldba.

I've always used database snapshots for this kind of thing. But this is when such updates to a table are planned and controlled and a snapshot can be created right...

Seconding Jeff on the SAN Replication if its available.

I've used that for almost exactly this kind fo work and it was AWESOME.

We are actually going through a very similar problem at the moment with an inherited database. Each iteration of the DB was done so by another short term project-scoped contractor...

Cheers John for the block size link.

Jeff this is an entirely unused server, and is purely being used for testing the collation change.

What is performing really slow is putting a primary key back on...

Hi John

MAXDOP is set to unrestricted (0), meanwhile threshold for parallelism is the default of 5.

The logs are not separated but are on a VM on...

Oh. I should add that there is BLOB data this time around. I somehow missed it when I was originally looking at it. So it has 500+ million of data...

Hi John,

To me the waits some non-eventful. Bear in mind this is a brand new instance with nothing else running on there. Just me and the scripts above,...

Ah yes it is internally used and is added to a domain, and is in fact currently controlled by an AD Group. But the brass here quite specifically want it...

I am trying achieve both high availability (each server is in a different DC) and some positive performance impact by having 2 (or more) SSRS servers.

But now you...