the idea for today is to cause #sqlserver [total server memory] to exceed [target server memory] by several gb with a rowstore-only workload and *then* read columnstore segments into buffer pool (and column store object pool).
while there are no columnstore related pages in bpool and columnstore object pool does not exist, the impossibly-high [target pages] value means almost no SQLOS free memory on the system.
initializing column store object pool brings [target pages] to a value well under [target server memory (kb)] - though, note [target pages] is measured in 8kb pages.
the result is a rapid increase of SQLOS free memory as pages from bpool are freed. but if the rate of freeing bpool pages is less than the rate of reading new pages into bpool while free memory is growing… #sqlserver [total server memory] will try to grow even more past target.
that’s the theory.
let’s see if I can realize it.

• • •

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

Keep Current with L_ N___

L_  N___ Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

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

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @sqL_handLe

12 Jan
trying to reproduce a system issue that presents itself in a complex ETL when run at full scale on a given system is tough.
but it’s a task i can do sometimes, and want to be able to do more often.
it’s an important task bc attaching a debugger to production is risky. and extended events is of limited use when some system symptoms are known but query/worker/memory condition contributors aren’t.
the rules of the game: i almost never get to work with the production system itself. can supply some low-impact information gather/logging tools.
probably won’t be able to work with production data in nonprofit database, either.
Read 38 tweets
12 Jan
i still can’t separate Bill Cosby from Cliff Huxtable.
doesn’t just keep me from watching the Cosby Show; keeps me from referencing some great scenes from the show i think many people my age know well.
that’s a shame, especially considering all the other talent & people involved.
When Denise made Theo that “cool” shirt?! 🤣
Even when Theo dumps his heart out(although not fully on the up-and-up) to his dad, saying “i’m not like you and i just wish you’d accept me for who i am!?”
that was good stuff.
Read 4 tweets
12 Jan
did i buy AppleCare for my 10 yro’s iPhone or not?
the receipt search begins.
i wonder if my 10 yro’s phone will tell me if it’s covered by applecare?
rear cameras, flash, flashlight no longer work :-(
Read 5 tweets
12 Jan
meaningful use of a 3d graph (rather than stacked/layered/mixed line + area 2d graph) would be unlocking a whole new achievement for me.
my imagination is so thoroughly 2d-based. i can imagine 2d objects in motion: waves, gears, spinning plates. But 3d is a problem for me.
my 17 yro daughter took a wood shop class maybe two years ago. she made a small puzzle cube - four, maybe five pieces.
took it apart in front of me. Put it together. Took it apart and gave me the pieces.
i tried for 30 minutes and couldn’t make a cube again 🤣
Read 5 tweets
12 Jan
Y’all. in your 3 am glitter adventures, please only enter when invited; and don’t break any windows. Be like glitter vampyres, k?

but… look at those smiles. i kinda wanna hear their story.
~~
Women arrested after throwing glitter at man
2022 January 11
fox13news.com/news/clearwate…
i want to know if the coppers followed a glitter trail to their still-warm car. (according to the police the car was still warm, and glitter was found in the car.)
i also wanna know if those mugshots were from this incident or priors 🤣
What i’m sayin’ is, as long as my kids follow the rules (no B&E, no substantial battery, glitter can’t still be in the container when they throw it), if they get arrested for a glittering… i’ll be good for bail/bond with a quickness.
Read 6 tweets
12 Jan
when do the stories people believe about a work of art, regardless of artist intent or history of the piece, become a part of the work of art?
i don’t know.
working with a database engine, i’m an absolute stickler for “design intent” as revealed by documentation and historical development.
i have a particular view of RDBMS cpu scheduling and memory management: unless documented otherwise (in detail with boundaries), if an user query workload with no external calls makes the system unresponsive due to cpu or memory saturation, it’s a bug.
Read 7 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(