stop the merry-go-round - 2019-04-17 (page 2 of 2)

lemme see if I can get this dump to complete (14 minutes in) - yanking the other open in WinDBG didn't show the thread issue I don't think...so trying to get a good one

Sean Gallardy

What was the dump reason for the one you opened?

Nick Craver

honestly don't know - the AG in windows on one restart was bouncing up and down and dumping every time

hadn't had time to look yet since that was a separate thing

(cluster resource I mean)

Sean Gallardy

5:15 PM

gotcha, no worries :)

Erik Darling

2spicy4chat

Joe Obbish

tru

Erik Darling

that's alright, you're all worked up

joe smelled a beer

he's off the chain

Joe Obbish

ahem

Nick Craver

just curious - what's the longest someone has seen dbcc stackdump take on a ~95GB process?

Joe Obbish

5:25 PM

last time I had a bunch of stack dumps it took around 15 s on a 96 core system

Sean Gallardy

30 mins or so, they had really bad storage

Joe Obbish

although that was with a stackdump caused by sql server, not DBCC STACKDUMP

Sean Gallardy

I have to run for the day, though

Nick Craver

so say 32 logical cores and PCIe SSDs 26+ minutes sounds bad

@SeanGallardy I appreciate the help!

Joe Obbish

so I guess I have nothing helpful to say

Sean Gallardy

5:26 PM

@NickCraver Yeah I think we need to investigate this, I'd like to look into it more on an unofficial basis and bring it up to the devs in our weekly meeting if I find anything interesting

Nick Craver

think starting a case today would be fruitful?

Sean Gallardy

Yes and no

If you do start one, I'd like to work with you on it

I'm betting Curt would be interested as well

Nick Craver

k - what's the best way, just ping via email once open and mention in the ticket?

Joe Obbish

@SeanGallardy funny how you've never said that about my support tickets...

Sean Gallardy

Yeah, that would work. I can pull it and jut work with you over it. If you do and I can grab it in time (I'm off today, I'll be back tomorrow) then I'll do some internal stuff to get things already moving

@JoeObbish I told you I'd always work with you on your tickets

Joe Obbish

5:28 PM

lies

Sean Gallardy

I <3 you Joe, you know that

@NickCraver This way I can bypass much of the stuff you'd initially get and we can just dig right in

the stackdump time is making me a bit antsy, though, it really shouldn't take that long

Ok sorry to take over the room, I have to run though - Nick, feel free to email me and stuff :)

Nick Craver

I'm going to kill the process and get it earlier on with a full windows dump first for insurance, then a minidump attempt

thanks!

Paul White

what does OOF mean?

Joe Obbish

out of office is how we describe it

I don't remember what the F is for

Paul White

I thought that was OOO?

Joe Obbish

5:33 PM

right, I'm saying that OOO = OOF AFAIK

Paul White

I see

Joe Obbish

I've seen other Microsoft folks use it in that context

Erik Darling

out of frigs (to give)

Joe Obbish

I really can't think of what the F means

Erik Darling

or fricks

Paul White

5:36 PM

I thought maybe Overseas Observing France

Maybe Out of Office on Fridays

Taryn

it's not friday!

Joe Obbish

every day is Friday at Microsoft

Paul White

Sean rarely makes sense

He probably uses some weird Texas calendar

Joe Obbish

blogs.technet.microsoft.com/exchange/2004/07/12/…

it doesn't even stand for anything!

well I guess it does, "Out of Facility"

Paul White

helpful

what has happened to this room

Joe Obbish

5:39 PM

we did have a bad day today

we should all reflect on what went wrong and what we could have done differently

Taryn

@JoeObbish blame @JoshDarnell - chat.stackexchange.com/transcript/message/49953519#49953519

he started it

Joe Obbish

looks like Erik's fault

Erik Darling

WAIT WHAT

impossible

Joe Obbish

5 hours ago, by Erik Darling

@Taryn have you tried disabling parallel redo on secondaries?

Erik Darling

i've never been helpful

Joe Obbish

5:46 PM

that's the first helpful comment

Erik Darling

i refuse to believe it

we've been HACKED

Joe Obbish

transcript doesn't lie

except when Erik changes it

Erik Darling

someone sweep the room for cyrillic characters

Paul White

none found

Erik Darling

alright well

Forrest

5:57 PM

молодец

Erik Darling

i guess i've been helpful once since the room started

i feel shame, but it will pass

Paul White

return of the Lamak

Josh Darnell

6:34 PM

@Taryn Hey!

I'm going to have to unfollow Grant Fritchey on Twitter.

Am I anti-community?

Erik Darling

BUT WHY

Josh Darnell

20 tweets today.

Joe Obbish

this is the best BOL example of all time: docs.microsoft.com/en-us/sql/t-sql/statements/…

Josh Darnell

Most of them are weird and / or not very interesting to me.

Erik Darling

@JoshDarnell apt description of grant 😂

@JoeObbish which one?

Joe Obbish

6:45 PM

the one I linked

Josh Darnell

@ErikDarling Haha messed up.

> This example grant permission required to execute ALTER DATABASE SCOPED CONFIGURATION to user Joe.

Joe is famous now.

Josh Darnell

6:59 PM

0

A: Is there a way to retrieve the logical filename from a backup file?

I wrote a blog post at SQLServerScience.com. The post shows how to obtain the details you're after, and is compatible with all versions of SQL Server since 2008+

Trusted user

😁

Erik Darling

never should have given him a hat

Max Vernon

8:03 PM

I should change the link in that answer to tinyurl.com/RollinOn

Josh Darnell

8:26 PM

I keep checking those two links and I don't see a difference.

ypercubeᵀᴹ

8:44 PM

Single-sentence-answers are rarely helpful. Perhaps you could expand your answer to make it clearer what you are recommending, and why that will help. Also, please take the tour. — Max Vernon Jan 24 at 19:11

with all my love ;)

Max Vernon

@ypercubeᵀᴹ what can I say, it has two sentences ;-)

I added the code from my blog post.

ypercubeᵀᴹ

9:00 PM

@MaxVernon I was too tired to look for a more appropriate comment. Sorry

Max Vernon

@ypercubeᵀᴹ no worries, I was just being silly

Max Vernon

9:39 PM

@ErikDarling that went from zero to hero in just one hour. The OP accepted the answer now.

Erik Darling

hopefully no one un-upvotes you

Josh Darnell

@MaxVernon Well it was entirely your fault that it didn't start out hero.

Max Vernon

@JoshDarnell very true

Erik Darling

10:59 PM

0

Q: Azure SQL Server - big query choosing bad execution plan

I'm using Azure SQL Server v12 and I have big, complex query that runs ok but when I add more joins, it doesn't matter which table I'm joining to, it gets super slow. The important thing to point out is that by adding a simple join it's choosing a different execution for the whole query and I rec...

> I cannot post the query or the execution plan but I want to know if someone faced a similar case. My intuition tells me that SQL Server is choosing a bad execution plan because the query is so big that it times out when it tries to pick one.

Joe Obbish

@ErikDarling for u

anyone on that VARCHAR(MAX) question or should I take it?

Erik Darling

all you

i answered the other one

i also voted to close it

Joe Obbish

only a sith answers and then votes to close

Erik Darling

fuck is a sith

Joe Obbish