Infuriatingly Fun Performance Puzzlers

It’s been a little while, but you might remember our friend George who’s been working on performance for awhile now. This time he sees the CPU % was maxed out on the database server, there were no sessions blocked or locked, the I/O was throttled at 1 GBit/sec. The end users were complaining that reports just weren’t getting through on time, but the data was flowing faster than normal.

This entertaining and mentally frustrating session will present several “somewhat common” performance puzzlers and give attendees time to work in small groups to see if they can determine the root-cause for the performance issue. Bonus points will be given for proper recommendation for a fix to the problem. Additional bonus points will be given for recommending what type of testing may have prevented the specific issue.

Session Takeaways:

  • Practice of performance problem-solving techniques.
  • Specific performance problem identification and remedy.
  • Practical application of root-cause analysis skills.
  • Group collaboration on performance analysis.

Location: Middlesex Date: October 8, 2015 Time: 10:15 am - 11:15 am Mark Tomlinson - STPCon Fall 2014 Mark Tomlinson