« first day (4416 days earlier)      last day (445 days later) » 

4:42 AM
love me some sql dumps in the evening
SqlDumpExceptionHandler: Process 8908 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

00 sqllang!FReadDataDirect
01 sqllang!CNetConnection::FReadTdsPacket
 
Sounds like a driver problem
Are you driving that database
If so, it's your problem
HtH
 
 
2 hours later…
7:04 AM
Morning
 
7:17 AM
Morning
 
7:40 AM
@PaulWhite I could add at least three more items.
 
 
1 hour later…
9:01 AM
Any idea what a wait resource FILE: 42:0 represents? I'm guessing 42 is the file id, but what's the 0?
 
 
1 hour later…
10:06 AM
@Zikato In which context? DMV?
 
A chairde - Morning all!
 
blocked process report, but I'm sure it would be in a DMV as well
 
Lá Fhéile Bríde sona daoibh go léir! Holiday here in Ireland!
 
Merry Lá Fhéile Bríde sona daoibh go léir to you
 
10:50 AM
@Zikato Děkuji!
It's St. Bridget's day - an Irish saint (as most of us are! :-) ).
 
11:19 AM
Also Waitangi Day here
Waitangi Day (Māori: Te Rā o Waitangi), the national day of New Zealand, marks the anniversary of the initial signing—on 6 February 1840—of the Treaty of Waitangi. The Treaty of Waitangi was an agreement towards British sovereignty by representatives of the Crown and indigenous Māori chiefs, and so is regarded by many as the founding document of the nation. Waitangi Day was first celebrated in 1934, and it was made a national public holiday in 1974. The anniversary is marked annually on 6 February, and a public holiday is observed on the day, or if the date falls on a Saturday or Sunday then the...
@Zikato Possibly the subresource? Might be zero because unused in that scenario, but this is all just a wild guess
 
@PaulWhite Happy Waitangi Day! And you are correct, I just found it here: learn.microsoft.com/en-us/sql/relational-databases/…
 
11:42 AM
Second very large earthquake in Türkiye/Syria
Well over 1,000 dead reported already
 
12:28 PM
Massive disaster
 
 
1 hour later…
1:36 PM
Oh my god. That's just awful.
 
 
2 hours later…
3:33 PM
@swasheck That's a really weird place to get an AV
was the server oom?
 
4:00 PM
@PaulWhite have a very merry waitangi day
0
Q: SQL Server 2008 R2 - what is traceflag 1605

Craig EfreinWhat is traceflag 1605 in SQL Server 2008 R2. I haven't been able to find any documentation on it so far. Thank you, Craig

 
1
Q: MS SQL Server 2022 High CPU Usage Spikes Every Minute under no Load (Dual Processor)

MDRBrand new MS SQL Server Standard 2022 Installation on a Dual Xeon 3416 system doing nothing and configured to do nothing fancy. Every minute, on the minute for about 6 seconds there is a massive CPU SPike (lots of green/red (kernel?)) under no load/no queries. I have confirmed that when the spike...

> SuperFetch sounds like something that could potentially cause conflicts with SQL Server. After the fact I'm not seeing any major conflicts documented though.
 
...
Lots of weird questions today
 
4:20 PM
this is what we're left with
having answered all of the important questions about sql server
that no one has read the answers to
does the title "dba" give anyone else the cringes?
every time i encounter it i twitch a little
 
Maybe they found it in a crackerjack box
 
should have thrown it out
 
5:05 PM
I was surprised by how much SQL Server question activity there was over the weekend. Usually the overall new question count is quite low.
 
 
1 hour later…
6:28 PM
sometimes i avoid answering questions because i know op will ask a bunch of annoying question comments
3
 
 
2 hours later…
8:50 PM
5 x 7 x 11 x 13 x 19
I'm missing 17
 
9:22 PM
What about 15
 
9:42 PM
not a prime number
 
too divisive
 
@SeanGallardy yeah. it was.
 
@swasheck That tracks, that's why I asked :)
Otherwise that's a really weird place to AV
 
it was a dev azure vm that someone was testing with some truly horrifying queries
 
Ideally it shouldn't AV, even under OOM
 
9:55 PM
ideally you're correct
 
I'm sure, somewhere, the code just assumes it obtains a memory allocation for the network read
 
likely
@ErikDarling i strive for a .33333 whilst on call
a full 1/3 of my blood shall be tequila
 

« first day (4416 days earlier)      last day (445 days later) »