« first day (4649 days earlier)      last day (373 days later) » 

John K. N.
John K. N.
5:20 AM
Wordle 830 3/6*

🟩⬛⬛🟨⬛
🟩🟨🟩⬛🟩
🟩🟩🟩🟩🟩
Zikato
Zikato
5:54 AM
🐅 Animal #58 🐈‍⬛
I figured it out in 5 guesses!
🟥🟥🟨🟨🟩
🔥 3 | Avg. Guesses: 6.3

https://metazooa.com/
#metazooa
Paul White
Paul White
6:17 AM
@ErikDarling I like them all, including the later reverse side rope text. Can't split them
Isn't the Big Top full of 🤡🤡🤡 though?
It's a brand association but maybe not the good kind
Irony and context notwithstanding
 
1 hour later…
John K. N.
John K. N.
7:36 AM
🐍 Animal #58 🦌
I figured it out in 10 guesses!
🟥🟥🟧🟧🟧🟧🟧🟧🟨🟩
🔥 3 | Avg. Guesses: 11.6

https://metazooa.com/
#metazooa
user image
Google's 25th anniversary!
 
1 hour later…
Michael Green
Michael Green
8:57 AM
@ErikDarling "Big top" makes me think of circuses. Then again "♫ Send in the ... ♫" etc.
Good morning all.
 
2 hours later…
Zikato
Zikato
10:59 AM
I've got an interesting problem. App calls a proc which updates a single row in a table (< 0sec) but only releases the lock after 30 sec. The proc isn't nested and there should be no transaction created in the app (as far as I've been told)
The only suspicious thing was that the connection is using MARS, but I don't know enough about it
there is probably a 30 seconds to MARS joke somewhere
2
 
1 hour later…
J.D.
J.D.
12:09 PM
@Zikato Curious, how are you measuring lock time outside of the runtime?
Zikato
Zikato
lock acquired/released vs module_start/end
John K. N.
John K. N.
ASYNC_NETWORK_IO
Josh Darnell
Josh Darnell
@Zikato Do you know if the query is generated by EF / EF Core?
Zikato
Zikato
No significant wait stats, no EF / EF Core.
Paul White
Paul White
12:36 PM
> there should be no transaction created in the app (as far as I've been told)
You've been OPed
Zikato
Zikato
It's possible, but I lack the skill to debug that on the app side
J.D.
J.D.
@Zikato is that measured via Extended Events, or what's your trace tool of choice here?
Zikato
Zikato
extended events
I think it must be a transaction somewhere. Because the blocked process report shows an unrelated procedure as the main blocker.

But I don't know how to prove it or trace it further
Erik Darling
Erik Darling
is there a trigger involved somewhere
foreign key nonsense
implicit transactions
i wonder if mars needs implicit transactions for some reason
Paul White
Paul White
12:58 PM
MARS is quite weird
But I don't know heaps about its detailed behaviour with locks and whatnot
Transactions get batch-scoped
Zikato
Zikato
Since it spans (at least) two separate RPC calls then it must be on the app side, right?
Paul White
Paul White
1:13 PM
it?
Zikato
Zikato
transaction (I presume)
or anything else that would keep the locks
JukEboX
JukEboX
Morning All
 
1 hour later…
J.D.
J.D.
2:18 PM
Morning
 
1 hour later…
Vérace
Vérace
3:18 PM
A chairde - Morning all!
Erik Darling
Erik Darling
🌕🦇
 
1 hour later…
JukEboX
JukEboX
4:33 PM
Oh jeez
DROP PROCEDURE @_@
 
2 hours later…
Sean Gallardy
Sean Gallardy
6:52 PM
J.D. lakhs answers today
Cade Roux
Cade Roux
7:50 PM
🐕‍🦺 Animal #58 🐸
I figured it out in 3 guesses!
🟧🟩🟩
🔥 1 | Avg. Guesses: 10.5

https://metazooa.com/
#metazooa
Well, that was impressive
Erik Darling
Erik Darling
i'm going to start an online game where people have to guess the source of a smell based on the description
Sean Gallardy
Sean Gallardy
I gagged a little just reading that sentence
J.D.
J.D.
8:06 PM
@CadeRoux nice! 👍
@SeanGallardy nothing new there. 🫣
Vérace
Vérace
9:04 PM
@SeanGallardy Maybe even crores?

« first day (4649 days earlier)      last day (373 days later) »