good of you to post us your update

you should have a quick look at Grant Fritchey's site - he despises profiler traces and loves XE

https://www.scarydba.com/2020/02/03/profiler-time-to-go/

you might pick up a few...

a few years ago, I encountered an issue for a large retail company. Every single point of sale system stopped. the issue was that they had cloned the deployment server...

you don't need the select

example

INSERT INTO Customer (FirstName, LastName, City, Country, Phone)

VALUES ('Craig', 'Smith', 'New York', 'USA', 1-01-993 2800)

Dino - all good points.....but

i can't see how you can...

just out of curiosity. is the log growing and stays 100% full? or does it grow and then space is released and it refills?

if it is the former then it...

I'm not kidding about the plan by the way - I picked the 2 main elements and set them to fit to screen

I haven't factored in the parallelism issue so far - but yes, a lot of the time "part" of the plan goes parallel, I was kinda thinking it might have ...

Jeffrey is correct in asking the largest table size

i'd also ask.. are you doing index rebuilds or index defrags... a rebuild will take the whole index and churn it up...

we didn't know that you didn't...

you will never find @p1 in your codebase.

easiest way to see it it to run a profiler trace from sal management studio and see the queries coming through - not...

that is what my IT director keeps telling me...

@p1 is generated by sql and your sql driver for prepared statements it's not in PHP

upgrade quickly, then you can use querystore and plan guides

I'm stretching here on this one (and i'll get shot down) - if it works on one server but not on another then it's either a database or server setting.

if...

I used to work for a cyber security and anti-virus company. a lot of the research team used to put black insulation tape on phone cameras (both sides) and laptop...