SQLBits 2019
Making Managed Instance Perform, a dive into storage.
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance included, get the storage configuration wrong and it will not perform. We'll look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance is a case in point, get the storage configuration wrong and it will not perform. Together we will look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need. Of course none of this is any use without knowing what level of performance you need so we will look at how you can get this information before you start testing.
Speakers
John Martin's previous sessions
The Swiss Cheese Security Pattern
Understanding that there is no panacea when it comes to securing your data assets is important. We will look at how to adopt the right mindset and then build a secure architecture to minimise the risk to your data.
Introduction to Infrastructure as Code with Terraform
Join John as he introduces Terraform as a cloud agnostic management interface for taking a code first approach to cloud infrastrucutre deployments.
Making Managed Instance Perform, a dive into storage.
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance included, get the storage configuration wrong and it will not perform. We'll look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need
In-Memory OLTP, how to use it
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability.