Special Guest: Ember Crooks
Show Host Scott Hayes Commentary
Again, it was an honor and a pleasure to have Ember Crooks as our special guest. She's got a real gift for teaching that includes making complex topics seem understandable. She offered great advice and recommendations for Db2 logging during this session. I'll be watching this replay myself and checking configuration settings on some of my favorite databases.
More shows Featuring Ember Crooks
Check out these replays of past shows:
- Episode #194: Interviewing the Db2 LUW Optimizer ( Explains Explained in English! )
- Episode #164: 8 High-Impact Performance Tuning Tips for DB2 LUW
- Episode #133, Why Low Cardinality Indexes (STINK)
- Episode #143, HADR and TSAMP Advanced Topics
- Episode #66, Top 10 Tips for E-Commerce Databases
A message from our sponsor:
During today's quick 1 minute commercial, DBI demonstrated the Brother-Thoroughbred® component of the DBI pureFeat™ Performance Management Suite for IBM Db2. Brother-Thoroughbred shows average transaction response times, how much time is spent inside Db2 and out, and, within Db2 time, where that time is spent so you can quickly see if a performance issue belongs to Db2 or not, and, if so, where the bottleneck is within Db2.
Working with DBI is like making money magically appear!
Typical customers enjoy 40-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 SUCCESS STORY with HealthPlan Services, do your 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. 8 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? 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! Join The DB2Night Show LinkedIn Group!
Get the Download Replays
WMV Format - approximately 90MB
To download a recorded replay of Episode #196 in WMV format, right click on
the link below and choose "Save As..."
Episode #196, 22 September 2017, SQL Infusion - A transaction log expedition with Ember Crooks!
MP4 Format - standard resolution - 113MB
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!
Ember presented this session at IDUG Anaheim 2017, and will be presenting it again at IDUG Lisbon 2017. A PDF is available to IDUG attendees. Or, try emailing Ember to request a PDF.
Sharing is Caring!Share a great show with your friends and followers!