Welcome to the official SQLPass Chapter for Hertfordshire.
Next Meeting: Wednesday 9th July, 6pm - 8pm at Jury's Inn, Watford
SQL Server Performance Diagnosis and Query Tuning - A SQLBits preview ** Cancelled * We now have a revised session
Waits, Latches, and Spinlocks: Internals and Analysis [DBA-503-S]
PASS Summit 2013 Session Recording of Paul Randal's Session
** Note Venue change to Jury's Inn, Watford **
Register by clicking here.
One of the first things you should check when investigating performance issues is wait statistics, which can often point you in the right direction for further analysis. Unfortunately, many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem, resulting in “knee-jerk performance tuning.” Below waits are layers of synchronization complexity, called latches and spinlocks. In this deep and detailed session, you’ll learn what waits, latches, and spinlocks are; how to analyze them; and potential solutions to common problem patterns.
Paul Randal is the CEO and co-owner (with his wife, Kimberly Tripp) of SQLskills.com, a world-renowned training and consulting company. He worked on the SQL Server team for 9 years, most notably rewriting DBCC CHECKDB, and since then has been a SQL Server MVP and Microsoft Regional Director. Paul is an accomplished writer and presenter, with numerous books, articles, whitepapers, and conference top-speaker awards over the years. You can read more about Paul at www.SQLskills.com/about/paul-s-rand
Wednesday 9th July 18:00 - 20:00
In-Person RSVP URL: http://SimonSabinSQLBitsPreview.eventbrite.co.uk
There is a public car park nearby. Click here for a map.
Watford Junction Railway Station - 8 minute walk
Watford Met Line Tube Station - 2.5 km
M25 Junctions 18, 19 and 20 - 5 km
M1 Junction 6 - 8 km
Heathrow Airport - 40 km
London Luton Airport - 40 km
To Luton - GBP 10 - 40 (75 min with three changes)
To Heathrow - GBP 30 - 45 (90 min with two changes)
To and from Luton - GBP 2 (90 - 120 min)
To Luton - GBP 40 (30 min)
To Heathrow - GBP 50 (30 min)
To London city centre - GBP 65 (45 min)