indubitably
~~
"To conduct tactical monitoring, we must also consider the complexities of virtualization, consolidation and concurrency alongside the activities of multiple CPU cores."
"... for capacity planning, this assumption is mostly harmless.
However, this assumption is reckless for tactical monitoring..."
gotta love it when an esteemed expert says the way you usually do something ranges in risk from mostly harmless to reckless...
😂🤣🙃
"while concurrent fragments of CPUcore time are working or waiting, they're unavailable to serve any other virtual CPU (of this or any other LPAR)."
i'm glad he used a term as direct as "reckless"
regardless of the virtualization platform, this idea is *very* important
that *right* there is what i was looking for this morning...
~~
"Do not confuse the two meanings of idle in AIX:vmstat –IWwt 1:cpu:id (figure 1) and AIX:mpstat –w 1:id (Figures 2 and 3)." techchannel.com/SMB/9/2017/aix…
i absolutely adore this turn of phrase
~~
"keep CPUcores fed, focused and furiously productive"
makes me wanna cry. that article is part 5.
it has links to the first 4 parts, but all of those links are broken.
the redirect from old ibmsystemmag links to techchannel isn't correct.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
just like that, i'm probably done thinking about scalabilty strategies for #sqlserver, and back to investigating latch timeouts on very busy systems.
here's the thing. the number of mdmp files for a given large-memory system can be pretty small, especially if an Availability Group is involved.
while a dump is in progress, #sqlserver memory must remain in a constant consistant state. the more memory, the longer the dump may take (there are other un-enumerated factors).
but, Availability Group lease timeout can only be set as high as 100 seconds currently.
484 #sqlserver batch mode on rowstore queries. DOP 8. run consecutively by a single session. each query is a fullscan of a different single table, grouping by a CASE statement on a non-indexed INT/BIGINT/NUMERIC data type column. producing one or two result rows of 1 column each.
based on observation of the first experiment with these queries, in which the queries were ordered alphabetically by the name of the only table in the FROM, i reordered the queries based on decreasing pages:rows ratio. that gives the evident decreasing pages/sec trend :-)
a closeup of the first 10 minutes shows the considerable variation even though the downward trend is evident.
wow
~~
Oracle in Talks to Buy Cerner
An agreement, which could potentially be worth $30 billion, would rank as biggest ever for software giant
2021 December 16 wsj.com/articles/oracl…
i don't know i've ever heard a story about Oracle in talks to buy a company with an ending other than Oracle *buying* that company.
oh. i forgot about the TikTok debacle, mentioned by Financial TImes here.
so that's *one* story about Oracle not buying.
~~
Oracle nears deal to buy health IT company Cerner for $30bn
2021 December 16 ft.com/content/9bf806…
i'll nitpick two details, though :-)
the 512k upper bound for disk IO size isn't properly a #sqlserver limit, although it *is* the limit on most systems. it's the upper bound of the disk adapter.
some disk adapters - most fibre channel HBAs and some others, too - allow configuration of the maximum disk transfer size, and can be set higher than 512kb.
Startling?
~~
We invited an AI to debate its own ethics in the Oxford Union – what it said was startling
2021 December 10 theconversation.com/we-invited-an-…
Startlingly... ridiculous!
"The good news is that you don’t have to build your own AI team. You can outsource your AI work to experts in the field, which can help you make the most of technology and ensure that you don’t fall victim to the same AI problems as your competitors."