I'm not sure you have a spinlock problem based on what you've posted. I'd suggest more reading here and here (especially Paul's post).

In general, start with wait statistics...

That's not a shock really. But a little more sharing ahead of time, might, might, prevent some outages.

AND

on this note, SQL Server on Edge is now in...

Yeah, that qualifies.

Congrats on the license upgrade. one more level to go.

We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or cheaper...

thanks Grant, now I can't CC anyone on an email without feeling guilty (and buying cakes for everyone.)

I used to be cranky, but now i'm the nice DBA who...

Welcome to the...

You have a starting point. There are some primary keys. Heck there are two foreign keys that I saw. So, again, this is largely a paper process to start, spread...

Agreed. Excellent point.

I'll be the angel of death this time:

https://www.bbc.com/news/entertainment-arts-51209197

I'd love to say, he's not quite dead.

Yep. Sorry. Totally got that wrong. I must have been thinking of telnet. Apologies.

Wow. You're in a tough spot. There is a very high likelihood that the business also doesn't know how these tables match. Personally, I'd suggest you bring some tooling into...

Dutch Girl

Thanks for the feedback @rod at work. I've pulled back from some online communities because of the negativity. Life is far too short and painful on it's own to intentionally...

his response "we're so used to it breaking we've stopped complaining" - these are really valuable unknowns that we need to start knowing. my personal opinion is that getting...