- 18:15 - Registration, Introductions
- 18:30 - Speaker 1
- 19:30 - Samosas
- 19:45 - Speaker 2
- 20:45 - Pub
The NUMA memory internals of SQL Server
If you use instances of SQL Server on large physical servers, you might be familiar with the term NUMA.
It's a physical server memory architecture that helps maintain system performance as the amount of memory increases.
While we might conceptually understand what NUMA is about, we often don’t appreciate the subtle changes to how Windows and SQLOS work when they run on a NUMA architecture server.
To help understand those changes, this session will cover:
What is NUMA and why it exists,
How Windows responds to NUMA hardware
How SQL Server changes its behaviour in the NUMA world.
We’ll then look at some of the benefits NUMA brings us and how we sometimes need to adapt our monitoring for the NUMA world.
Gavin is a senior IT architect, leading and delivering enterprise and solution level projects.
He has a breadth of technical experience across all areas of IT, with deep expertise in Microsoft's data platform and cloud products and technologies. His hands-on technical activities focus on SQL Server, Windows Server, and Microsoft Azure.
Gavin is also one of 25 Microsoft Certified Architects for SQL Server in the world and a Microsoft Certified Master. He also holds certification from the Global IT Architect Association, IASA.
Estimation, Statistics : The basis of query optimization
At the heart of SQL Server is the cost based optimizer. Stop and think about that a minute, it
attempts to give the “best plan” based on the cost of the work undertaken. How does it know the cost of the work before
its done the work ? This isn’t a conundrum, it doesn’t. It estimates!
How does it estimate ? That is statistics.
This will be a deep dive into how the optimizer makes its
decisions to give you a plan, the things that can go wrong and how you can have
influence over these choices.
Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment.
Dave is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the SQLLunch/SQLSupper User Groups.