stop the merry-go-round - 2019-06-26 (page 2 of 2)

We have a SQL Server 2016 Availability Group with 3 servers. Twice in the past 5 days we have had performance issues. 8a is our primary server, and 8b and 8c are the secondaries. We started having issues right before 8PM. We saw timeouts as well as 502 Bad Gateway errors. On 8b and 8c we see...

Erik Darling

@JoeObbish tss you could run that on my headphones

@Taryn have you tried tf3459 or are you past that?

Taryn

we don't have that turned on for StackOverflow

Erik Darling

well the moral of the story is you should use log shipping

Joe Obbish

Erik wants to star in an anime about log shippan

How will LOG SHIPPAN MAN save the day today?

Lamak

8:34 PM

@ErikDarling is that really moral?

Erik Darling

by being STABLE and RELIABLE

1 hour later…

Joe Obbish

10:03 PM

Msg 1790, Level 16, State 1, Line 3
The name of a user-defined table type cannot start with a number (#) sign.

foiled again

Erik Darling

10:43 PM

Supremely

Sean Gallardy

Like I said, stop rebuilding indexes

Taryn

@SeanGallardy pfft...never

Sean Gallardy

something something cries when you rebuild indexes

it's SQL madlibs

fill in the somethings

Taryn

just fix all the AG issues, Sean and it will work for us

Sean Gallardy

I'm on it

ALL OF THEM

Taryn

10:56 PM

work faster!

Sean Gallardy

I'm running out of hamsters to run on wheels to power my laptop

Joe Obbish

@ErikDarling Do I have to worry about performing mundane DBA tasks like rebuilding indexes if I use the superior Log Shipping technology?

Sean Gallardy

Ever get that data all migrated?

Joe Obbish

@SeanGallardy yes, thanks for asking buddy!

Taryn

@SeanGallardy haha, actually I finished the bulk of it today. Took about 6 months.

Sean Gallardy

11:02 PM

@Taryn Yay, GRATZ!

@JoeObbish Gratz to you as well! Any good bus stories?

Taryn

@SeanGallardy It's a day to day move now until we finish the cutover and get new servers

Sean Gallardy

Is that better or worse?

Taryn

New servers will be great - we will no longer be on spinny disks.

Erik Darling

@JoeObbish not if you compress your log backups 😏

Sean Gallardy

Question for the room: Do you LOL, facepalm, stare into oblivion, or some combination of the aforementioned when someone tells you that, "Locking and Blocking are bugs in SQL Server and need to be fixed."

@Taryn I can get behind leaving spinny disks!

Also, day 4-ish of stomach meds and I haven't thrown up in the last 2 days. Progress.

Erik Darling

11:07 PM

@SeanGallardy no because rcsi should be the default 😉

Taryn

@SeanGallardy all of the above

Joe Obbish

@SeanGallardy we're seeing something that looks like an awful like an undetected deadlock on four customer systems

heard about it this week

Sean Gallardy

@ErikDarling RCSI might not meet your requirements, versioned data may not be allowed