Tweet

L_ N___

31 Mar, 5 tweets, 1 min read

my 16 yro daughter asked me if i know what happened to the vanilla ice cream

though i truthfully denied any knowledge i can't stop laughing
#pleaseSendHelp

to the esteemed members of the jury, i state that laughter could mean anything.

"you sound kinda sus right now"

first, she asked about the ice cream.
then she asked if i was laughing. i said no.
then she told me i sounded like i was laughing.
then i started laughing.
is this entrapment?

i laugh loudly. and she knows it.
this was entrapment.

• • •

Missing some Tweet in this thread? You can try to force a refresh

This Thread may be Removed Anytime!

Twitter may remove this content at anytime! Save it as PDF for later use!

More from @sqL_handLe

L_ N___

@sqL_handLe

30 Mar

och. the stuff i'm looking at today has so many variables and so much variability its about to do me in.

i'm trying to help optimize work in a workload group with a small footprint of concurrent queries and workers while other workload groups are active.

the gray inside the red-dashed-line boxes - that's what i'm trying to help out. without doing unnecessary damage to the other workload groups.
might be a long haul.

its hard to pick out the CPU utilization for just that workload group from 3 am to 6 am.

and the waits it experiences aren't all that easy to eliminate (memory_allocation_ext waits).

Read 47 tweets

L_ N___

@sqL_handLe

30 Mar

there's some good stuff in here about #sqlserver soft-NUMA which applies to autosoftNUMA
~~
Understanding Non-uniform Memory Access
2012 October 4
docs.microsoft.com/en-us/previous…

"Memory nodes are created based on hardware NUMA and therefore not impacted by soft-NUMA."
Thumbs up! soft-numa nodes must be fully contained in memory nodes. so memory nodes enforce something on soft-numa, but not the other way 'round.

"Soft-NUMA does not provide memory to CPU affinity."
Thumbs up, i think. i guess i would probably have said that memory-to-cpu affinity is based on memory node rather than soft-NUMA node.

Read 15 tweets

L_ N___

@sqL_handLe

30 Mar

Dell EMC Host Connectivity Guide for Windows
P/N 300-000-603
REV 61
MAY 2020
9.5 mb pdf
delltechnologies.com/en-us/collater…

i've found that Execution Throttle was relied on so heavily in the past with QLogic HBAs that many folks are unfamilar with setting a per-LUN servic queue depth for QLogic in Windows.