Taryn

general recent conversations

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

Taryn

Dec 10, 2020 15:17

@JoshDarnell running an update in Production

Taryn

Oct 21, 2020 17:56

you mean this - dba.stackexchange.com/help/badges?

Taryn

Aug 25, 2020 14:17

@billinkc haha that works

Taryn

Aug 25, 2020 14:01

@billinkc cross DB queries :O

Taryn

Apr 1, 2020 14:36

@Marian not going that route since it would involve a significant change to Ola's backup script

Taryn

Apr 1, 2020 14:17

thanks I will. We also are suggesting a correlated subquery, which is faster as well. I'll credit you for the hash join :)

Taryn

Apr 1, 2020 14:14

I'm going to open a bug with him :|

Taryn

Apr 1, 2020 14:10

it did - went from elapsed time = 210281 ms. to elapsed time = 2309 ms.

Taryn

Apr 1, 2020 14:02

running that on our remote secondary with 370 databases takes 3.5 minutes

Taryn

Apr 1, 2020 14:02

alright here is the plan - brentozar.com/pastetheplan/?id=S1bpCfzvI this query is directly from Ola's script

Taryn

Apr 1, 2020 13:53

and this - twitter.com/tarynpivots/status/1245348385118437376

Taryn

Apr 1, 2020 13:51

it was taking about 3-4 hours, we're up to 22 hours

Taryn

Apr 1, 2020 13:50

yeah, probably - I can get you the plan shortly - it take about 4 minutes to run the query on our secondary - that makes taking backups super slow all of a sudden

Taryn

Apr 1, 2020 13:49

but it of course wasn't an issue in 2017

Taryn

Apr 1, 2020 13:49

we're seeing high waits for that

Taryn

Apr 1, 2020 13:49

it's the underlying HADR CLUSTER API call that appears to be the issue

Taryn

Apr 1, 2020 13:48

@PaulWhite9 it's part of Ola's backup script, let me get a snippet and the plan

Taryn

Mar 29, 2020 13:42

we did not hit this in 2017, and only popped up when we failed over to 2019

Taryn

Mar 29, 2020 13:41

@PaulWhite9 we are now. If we don't the t-log churn is hundreds of megs a minute

Taryn

Mar 29, 2020 13:29

taking dump files result in outages

Taryn

Mar 28, 2020 12:54

<it's happening.gif>

Taryn

Feb 26, 2020 17:10

we almost scheduled the SQL upgrade for this Saturday

Taryn

Feb 26, 2020 16:15

@ypercubeᵀᴹ not sure, I'd have to dig into the code.

Taryn

Feb 26, 2020 15:56

@PaulWhite9 it was added far later - there wasn't voting on comments when they were originally added

Taryn

Feb 26, 2020 15:53

@PaulWhite9 I'm trying to get the answer to this.

Taryn

Feb 26, 2020 11:06

@PaulWhite9 everything

Taryn

Feb 24, 2020 15:39

@James it tried to yesterday - twitter.com/tarynpivots/status/1231570124483645442

Taryn

Feb 18, 2020 15:53

hoping to be in 2019 by end of March

Taryn

Feb 18, 2020 15:53

@PeterVandivier we're not 2019 in prod...yet, so it was all done in dev

Taryn

Feb 18, 2020 15:51

@PeterVandivier you can use ALTER, they added details to the KB - support.microsoft.com/en-us/help/4538581/… - I used drop/create during testing with Joe

Taryn

Feb 18, 2020 15:35

per the suggestion of Joe Sack

Taryn

Feb 18, 2020 15:35

@PeterVandivier literally, drop function, and create function :|

Taryn

Feb 18, 2020 15:25

it was to those who interact with the community every day i.e. the CMs

Taryn

Feb 18, 2020 15:18

@PaulWhite9 I'll say that when that was asked internally, there were a lot of people that were surprised by the results. Not necessarily those who work with the community day in and day out.

Taryn

Feb 18, 2020 13:15

@AndriyM No, I don't know them, but it's just easier to flag and move on. I totally understand the desire to engage, but it doesn't do anyone any good

Taryn

Feb 18, 2020 13:05

hey y'all stop feeding the troll. Just flag and move on.

Taryn

Jan 28, 2020 13:13

@PaulWhite9 :(

Taryn

Jan 22, 2020 14:10

"Merge" was probably a poor word choice there. From my understanding, it's not a dump of all these scopes into Stack Overflow. It was meant to be something like showing other sites related to the topic in the sidebar similar to Teams, still independent with their own scopes, but much easier to navigate between and search content from one place. — animuson ♦ 22 hours ago

Taryn

Jan 22, 2020 14:10

I'm not involved with any of the discussions and anything is very early on, but I'll just point to this comment

Taryn

Jan 6, 2020 15:29

Suspend my account. We'll try this again in a year. — Robert Harvey yesterday

Taryn

Jan 6, 2020 15:29

@TomV-TeamMonica you're missing the key piece

Taryn

Nov 14, 2019 20:50

@PaulWhite oh it was a sql issue. Server spiked to 100% nothing could query it

Taryn

Nov 14, 2019 20:18

we're working on it

♦ stop the merry-go-round

Gallery room. Feel free to request write access if you read SQ...

Taryn

Dec 6, 2019 20:06

@JoeObbish you're welcome :)

Taryn

Nov 21, 2019 18:57

@PeterVandivier well it was a non-yielding scheduler, and I have some guesses as to why but will probably be opening a ticket about it

Taryn

Nov 13, 2019 18:25

to be fair, my brain was already melted for the day and 4:45PM for a 400 level session was going to be difficult to comprehend, but Joe's session was awesome and I learned a bunch

Taryn

Nov 13, 2019 18:24

I was attempting to distract you :P

Taryn

Nov 13, 2019 18:24

hahahahhaha

Taryn

Nov 13, 2019 18:23

@JoeObbish Well I do have a branding iron

Taryn

Nov 11, 2019 21:10

yeah it was great. Learned a lot and brain melted :)