Posted on 10/17/2015
@ember_crooks | Special Guest: Ember Crooks
DB2 Lead DBA & Delivery Manager, Xtivia
IBM DB2 GOLD Consultant8 High-Impact Performance Tuning Tips
for DB2 LUW OLTP & E-Commerce Databases97% of our audience learned something! Want to make your OLTP databases run faster? Ember offered eight terrific tips and sage advice for getting maximum performance from your transactional databases! Index Read Efficiency, finding problem SQL, finding index solutions, finding bad indexes and dropping them, pruning data, HADR impacts, when to use STMM and when NOT to use it, using parameter markers or STMT_CONC, and optimal use of Solid State Disk (SSD). Watch and learn... |
Show Host Scott Hayes CommentaryEmber has been attending my IDUG presentations for many years and it's been a pleasure to mentor her. No doubt, she's incredibly smart and talented. Somehow she's taken many of the things I've taught over the years and figured out how to do a better job presenting the ideas and concepts. Not only was Ember singing my songs today, but she's written some of her own hits too. Check out the SQL she wrote and shared in this presentation! It makes my brain hurt! Thank you Ember for an excellent presentation! DB2 Certification Book WinnerCongratulations to John Leggio at NTT Data in Hauppauge New York - You won the DB2 LUW 10.1/10.5 DB2 Certification Study Guide! We'll be in touch to arrange shipping details. More shows Featuring Ember CrooksCheck out these replays of past shows:
A message from our sponsor:
DBI SoftwareDuring today's quick 3 minute commercial, DBI demonstrated its new Advanced Index Benefit Analysis. When db2advis tells you that you can get a 98% cost improvement by creating several indexes, which indexes are the most beneficial? Which are marginally or minimally helpful? This challenge has plagued DBAs since Version 6 of DB2. Finally, DBI has automated answers for you! Don't skip the commercial!  | 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 GroupThe DB2Night Show has a LinkedIn Group. The "closed " group is open to any LinkedIn member. Join to receive LinkedIn group updates includingfuture shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group! Get the Download ReplaysClick Here for ReplaysPDF HandoutA PDF handout was distributed to live show attendees. Do you like handouts? Join our shows live! If our guest makes handouts available, they'll be distributed via GoToWebinar during the live shows. On the GoToWebinar tool, there's a tab that has "+ Handouts ". Click this and get the PDFs! Sharing is Caring!Share a great show with your friends and followers!
|