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

Language: English 

Event Type: 

In-Person RSVP URL: http://SimonSabinSQLBitsPreview.eventbrite.co.uk


Jurys Inn London Watford

Clarendon Road, Watford, WD17 1JA

Tel: +44 1923 422 800

Email: jurysinnwatford@jurysinns.com



Nearby transport

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)

Shuttle bus:

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)

There are currently no upcoming meetings scheduled. Please check back for updates.