SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Practical SQL Server Performance Troubleshooting
Description
In this precon we will take a default installation of SQL Server, and run a OLTP workload with a several hundred users to generate our initial baseline for performance tuning/troubleshooting. Throughout the day we will work across various areas of SQL Server to implement different performance optimizations, and check how those changes will impact the throughput of our test workload. At the end of the day we will have a well-performing SQL Server which can handle a much larger workload than the initial (default) installation.
Following areas are covered in this precon:
*) Windows OS Settings
*) Storage Configuration
*) SQL Server Instance Settings
*) Database Settings
*) Index/Statistics Maintenance
*) Locking/Blocking/Deadlocking
*) Memory Management
Following areas are covered in this precon:
*) Windows OS Settings
*) Storage Configuration
*) SQL Server Instance Settings
*) Database Settings
*) Index/Statistics Maintenance
*) Locking/Blocking/Deadlocking
*) Memory Management
Learning Objectives
Previous Experience
Tech Covered
performance, memory