The DB2Night Show #188: DB2 LUW Predictive Index Impact Analysis


Posted by scott on January 13, 2017, 3:05 pm
in DB2 LUW ( The DB2Night Show)







title="Scott Hayes on LinkedIn">
Scott Hayes, President DBI Software, IBM DB2 GOLD Consultant




@srhayes ::
@db2performance


Special Guest: Scott Hayes, DBI Software



Sage DB2 LUW Performance Advice

Predictive Index Impact Analysis -

Know Before you Create!



100% of our audience learned something! Sage Advice Part 3 - Predictive Index Impact Analysis - Know Before you Create - extends the performance tuning journey that began with Parts 1 and 2. Don't worry if you missed Parts 1 and 2 because they are briefly reviewed during this show, plus we have links to prior shows where you can watch the full presentations. Learn how to figure out what to fix or improve, then learn how to get optimized design solutions, and then, in Part 3, you will learn how to gain confidence in your solutions and make your change control people very happy! Watch and learn...








title="Scott Hayes on LinkedIn">
Scott Hayes, President DBI Software, IBM DB2 GOLD Consultant




@srhayes ::
@db2performance


Special Guest: Scott Hayes, DBI Software



Sage DB2 LUW Performance Advice

Predictive Index Impact Analysis -

Know Before you Create!



100% of our audience learned something! Sage Advice Part 3 - Predictive Index Impact Analysis - Know Before you Create - extends the performance tuning journey that began with Parts 1 and 2. Don't worry if you missed Parts 1 and 2 because they are briefly reviewed during this show, plus we have links to prior shows where you can watch the full presentations. Learn how to figure out what to fix or improve, then learn how to get optimized design solutions, and then, in Part 3, you will learn how to gain confidence in your solutions and make your change control people very happy! Watch and learn...






Show Host Scott Hayes Commentary



Double duty! Host and Guest! It was fun! I really enjoy giving this presentation because it will help people get Change Control approvals for performance improvements more easily and with greater confidence. No one likes making mistakes or having a bad performance day, so pay attention!


Congratulations!



Everyone that Attended today's show won a $10 Amazon.com gift card! DBI representatives will be following up with attendees to issue the gift cards, so please don't ignore that phone call from Austin Texas (area code 512) or that email from Rhonda, Chad, or Darin at DBI. It's true - Education does PAY - especially on The DB2Night Show!


Did you miss Sage Advice parts 1 and 2?


Check out these replays:






A message from our sponsor:

DBI Software



Let's just cut to the chase. DBAs spend hours and hours trying to figure out which indexes are the most beneficial, which to create, and which, if any, might be harmful. During this show's quick commercial, DBI demonstrated AUTOMATED Advanced Index Benefit Analysis AND Predictive Index Impact Analysis. You can spend hours doing the benefit analysis and calculations by hand, or you can get an accurate index benefit analysis with DBI in under a minute. Ready to save time and tune confidently?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI Now









Magic Hat Money

Working with DBI is like making money magically appear!


Typical customers enjoy 30-60% CPU utilization reductions in the first week, plus measurably faster
transaction and query response times. More importantly, your time savings will be substantial!
Read our newest title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">due diligence,
and speak with as many references as you have time to call.


We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior
DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce
performance on Black Friday multiple years in a row. 7 of the Top 25 Retailers, plus others, plus top Banks,
State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI






Join The DB2Night Show™ LinkedIn Group


The DB2Night Show™ has a LinkedIn Group. The
"closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including
future shows and replay information, and, if you like, start some discussions about the show! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!




Get the Download Replays



WMV Format - approximately 87MB


To download a recorded replay of Episode #188 in WMV format, right click on
the link below and choose "Save As..."


Episode #188, 13 January 2017,
DB2 LUW Sage Advice Part 3: Predictive Index Impact Analysis with host and guest Scott Hayes!



MP4 Format - standard resolution - 123MB



Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!



BONUS! PDF Handout!



A PDF handout is provided as reference material so that you can copy and paste many of the SQL commands. The PDF, alone, is not a substitute for what you will learn by watching the video replays. If you PROMISE to watch the video replays, then you are granted permission to CLICK HERE for the PDF.


Did you learn something from this show?



Share a great show with your friends and followers!

















Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=716