L_  N___ Profile picture
30 Mar, 9 tweets, 3 min read
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.
The Dell host connectivity guide i linked above in the thread discusses this on page 67.
Before changing LUN service queue depth regardless of host HBA make/model, consider. requirements/recommendations for the storage array.
Working in the past with EMC CLARiiON arrays and some of the older Hitachi arrays, there was good reason not to set higher than 32.
Why consider increasing LUN service queue depth from default?
Consider this example. Much higher average write service time in the dark blue box than the light blue box. Even though total bytes/sec is lower.
Looking at an individual LUN from perfmon, same comparison between dark blue and light blue boxes. Except bytes/sec is expectedly lower all around, and average write/sec service time is higher.
Looking at IOPs it's pretty much the same story. Neither bytes/sec nor IOPs explains the higher avg write service times in the dark blue box.
Saturated write cache, high pending writes, forced write cache flushes can elevate both write and read service times.

Something like a copy-on-write snapshot being maintained at that time of this capture could elevate avg write service times, too.
A COW snapshot would transform first writes into [read from source] + [write to snapshot] + [write to source] unless using a shadow filesystem strategy like NetApp.

COW without shadow filesystem is more painful on all HDDs than on an AFA, but there's still overhead on an AFA.

• • •

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

31 Mar
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"
Read 5 tweets
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. Image
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). Image
Read 44 tweets
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

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 Become our Patreon

Thank you for your support!

Follow Us on Twitter!