Calculating Average Record Size in DB2: A Comprehensive Guide
Learn how to accurately estimate Average Record Size in DB2. This is crucial for capacity planning & performance tuning. We explore various methods using DB2 system catalogs & RUNSTATS. #DB2 #Database #SQL #CapacityPlanning #PerformanceTuning #DataAnalysis
https://tech-champion.com/database/db2luw/calculating-average-record-size-in-db2-a-comprehensive-guide/
...
Recent searches
Search options
#performancetuning
2 posts1 participant0 posts today
Calculating Average Record Size in DB2: A Comprehensive Guide
Learn how to accurately estimate Average Record Size in DB2. This is crucial for capacity planning & performance tuning. We explore various methods using DB2 system catalogs & RUNSTATS. #DB2 #Database #SQL #CapacityPlanning #PerformanceTuning #DataAnalysis
https://tech-champion.com/database/db2luw/calculating-average-record-size-in-db2-a-comprehensive-guide/
...
About our ongoing efforts to deliver index monitoring for PostgreSQL.
I wrote about fillfactor how tos: https://ozkanpakdil.github.io/sql/postgresql/2025/02/18/create-select-postgresql-fill-factor.html
Software Engineer Özkan PakdilWhat is Fill Factor in PostgreSQLFillfactor in PostgreSQL is a parameter that sets the percentage of a data page to be filled with rows, leaving space for future updates to minimize page spl...
Ever wonder why your SQL queries are slow?
It’s time to crack the case with Query Execution Plans in SQL Server! Learn how to spot bottlenecks, optimize performance, and make your queries lightning-fast.
Dive in: https://woodruff.dev/cracking-the-code-decoding-query-plans-like-a-pro/
Chris Woody Woodruff · Cracking the Code: Decoding Query Plans Like a Pro - Chris Woody Woodrufflike at first glance—cryptic, overwhelming, and maybe a little intimidating. But don’t worry! Once you embark on the journey to analyze and understand query plans, you’ll be unlocking hidden performance treasures like a true database pirate, and you'll be amazed at how much you can grow and learn in the process.
Excellent #apachekafka performance analysis blog from Maciej Mościcki and Piotr Rżysko.
Nice methodical use of tcpdump, flame charts and more to pinpoint the issue and work out remedial steps.
https://blog.allegro.tech/2024/03/kafka-performance-analysis.html
Today I learned about string interning for performance in .NET!! Nikolay Mitikov wrote about how to improve performance of their high-memory app that wasn't letting go of enough string values and mentioned string interning for boolean values.
Make sure to check out this article if you want to learn about a few tricks for performance tuning with your string values!
https://makingitfaster.tips/2023/09/06/performance-crime-non-unique-strings/
A meeting is fundamentally a team endeavour and when responsibility, ownership, and accountability become blurred we are back to square one and having our time wasted in futile meetings. Yet, get it right and effective meetings become the space in our day we make to provide some sort of service to other people.
#Leadership #Management #OrganisationalBehaviour #CapabilityDevelopment #GrowthMindset #Value #PerformanceTuning #TransformationJourney
Dr Robert N. WinterRunning Effective MeetingsMeetings are the space in our day we make to provide some sort of service to other people.
'In a team with high psychological safety, teammates feel safe to take risks around their team members. They feel confident that no one on the team will embarrass or punish anyone else for admitting a mistake, asking a question, or offering a new idea.'
#Leadership #Management #OrganisationalBehaviour #CapabilityDevelopment #GrowthMindset #Value #PerformanceTuning #TransformationJourney #PsychologicalSafety
Dr Robert N. WinterA Psychological Safety PrimerGoing against the grain may make people feel unsafe, yet it is through this process that true psychological safety is ultimately achieved — because people feel safe to feel unsafe and to challenge the status quo.
Measuring and acting on an organisation’s DEI goals are critical elements for achieving internal impact. One path forward is for leaders to be more systematic early in strategy development, considering the objectives and desired level of impact from their programs.
#Leadership #Management #OrganisationalBehaviour #CapabilityDevelopment #GrowthMindset #Value #PerformanceTuning #TransformationJourney #Resilience #Adaptability #DEI
https://robert.winter.ink/dei-a-continuum-of-acceptance-understanding-and-questioning/
Dr Robert N. WinterDEI: A Continuum of Acceptance, Understanding, and QuestioningSuccessful DEI comes down to balance — ensuring that belief doesn't descend into ideology. A process that is founded on the bedrock of psychological safety.
To successfully navigate volatile environments, organisations need to adopt a process mindset that creates a culture of psychological safety, breeds team cohesion, promotes adaptable leadership, and emphasises agility.
#Leadership #Management #OrganisationalBehaviour #CapabilityDevelopment #GrowthMindset #Value #PerformanceTuning #TransformationJourney #Resilience #Adaptability
https://robert.winter.ink/forging-resilience-through-adaptability/
Dr Robert N. WinterForging Resilience Through AdaptabilityAs our adaptability mindset strengthens, resilience will also improve because individuals and teams are better equipped to absorb shocks today and use the energy to bounce forward into sustainable growth tomorrow.
Just as Covid and economic pressure drove up remote work opportunities, a sound conclusion is that the end of Covid restrictions and economic pressure can do the opposite — and drive down remote work opportunities.
#Leadership #Management #OrganisationalBehaviour #CapabilityDevelopment #GrowthMindset #Value #PerformanceTuning #TransformationJourney
Dr Robert N. WinterRemote Working PoliciesSetting boundaries will see some employee attrition, but those who remain will feel a heightened sense of trust and an improved quality of employment.
Once the capability gap is closed, instead of feeling fear and frustration about not knowing how to perform a role or achieve an outcome, staff are empowered to deliver value and be rewarded for their achievement.
#Leadership #Management #OrganisationalBehaviour #CapabilityDevelopment #GrowthMindset #Value #PerformanceTuning #TransformationJourney
Dr Robert N. WinterMinding the Capability GapOnce the capability gap is closed, instead of feeling fear and frustration about not knowing how to perform a role or achieve an outcome, staff are empowered to deliver value and be rewarded for their achievement.
PHP tip: Use 'strpos()' instead of 'strstr()' when checking for the existence of a substring, as it's faster and more efficient.
#PHP #PerformanceTuning
