As a Sql Server DBA at Transport for London a big part of my job is analysing sql performance and ensuring our applications scale. There are third party tools you can pay lots of money to do database performance analysis but these are really expensive and sometimes there isn't the budget for this. I decided to make my own. The first challenge was capturing metrics and then the second challenge was having a web front end that can quickly show developers where their applications are hurting. In this talk I will outline the approach I have taken to achieve this and demonstrate how I incorporated Django.
YOU MAY ALSO LIKE:
- µCon London 2019 - The Conference on Microservices, DDD & Software Architecture (in London on 29th - 31st May 2019)
- Keynote by Kris Nova: The Power of Linux Virtualization with Cloud Native (in London on 19th June 2019)
- Fast Track to Chaos Engineering with Russ Miles (in London on 1st - 3rd July 2019)
Using Django to Baseline and Analyse Sql Server Performance at Transport for London
Worked as a SQL Server DBA for 15 years and picked up Django as a hobby 3 years ago. He is now trying to make a transition into working full time in Python and ultimately working as a data scientist.