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.