Making your Emergency DBA Toolkit
You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems. We will walk through scripts that will help you pin point various issues quickly and efficiently. This session will take you through;
What’s on fire? – These scripts will help you diagnose what’s happening right now
Specs – What hardware are you dealing with here (you’ll need to know this to make the appropriate decisions)?
Settings – are the most important settings correct for your workload?
Bottlenecks – We’ll see if there are any areas of the system that are throttling us.
By the end of this session you should have the knowledge of what you need to do in order to start on your own kit. This kit is designed to be your lifeline to fix servers quickly and get them working.
All code we’ll go through is either provided as part of this presentation or are open source/community.
Getting Started with Query Performance
You've been writing queries for a while but you find yourself needing them to run faster, how do you measure them and increase performance?
In this session we'll go through some techniques to give you an idea what's happening inside the SQL Server engine and improve your queries.
We'll be going a few topics to give you a understanding on how you can increase performance.
- Execution Plan basics and how to read them
- SET Statistics options and tools
- Some common mistakes to avoid (cursors, scalar functions etc)
- Indexing and how it affects your queries
- SARGability - what it means and why it can make a massive difference
You should leave this session with the ability to analyse your own (and other's) queries and see where you might have performance bottlenecks and fix them!
Scale it Out (or: How I Learned To Stop The UDF's and Love Performance)
Scalar user defined functions seem like a great idea, you can put a bunch of code into a nice neat little package and call it from wherever you want. You do it and it runs great on your development environment so you deploy it. It's only then that users start complaining about poor performance, what do you do next?
In this session we'll cover why scalar functions don't scale well and what we can do about replacing them. We'll cover
- Row vs Set based logic
- How scalar functions don't scale
- Parallel vs Serial plans
- Why SET STATISTICS doesn't give the whole picture
There are a number of things we can do to get around this problem, we'll go through these and compare the performance of each.
We'll be using the Stack Overflow database and the scripts will be provided in advance of the session so you can follow along with the presentation.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top