11/11/2014 5:18:25 AM
While attending PASS in Seattle I convinced Paul and Kimberly to speak at our Christmas Party.
Food, drink, merriment and two world leading session on a SQL Server performance
Paul will explain how the threading lifecycle model works inside SQL Server, what wait statistics are and how they can be used for performance tuning, and briefly discuss some of the most common wait types and how to investigate them.
Kimberly will discuss the impact on caching / performance of different methods of statement execution. Briefly, she will also compare / contrast this with stored procedures. In the end, you’ll know the best way to request data so that stable requests are cached and unstable requests are not (giving you the most optimal performance).
Paul and Kimberly are running some "Emmersion Event" training in Sydney next year.
SQLskills.com is owned and run by the husband-and-wife team of Paul S. Randal and Kimberly L. Tripp, both world-renowned SQL Server experts, and long-time instructors and authors for Microsoft for their Microsoft-Certified-Master (MCM) certifications.
We’re different. We don’t advise baseless operational/design best-practices. We’re able to explain everything, to whatever depth you want to go based on our extensive industry experience with a broad range of clients.
Venue: Mechanics School of Arts, Level 1, 280 Pitt St, Sydney |
Duration 5:30 pm Pizza and drinks | 6 pm - 8pm Session |
On: Wednesday, December 10, 2014