>> Welcome back and welcome to module
4 where we're going to talk about performance.
Now Bob, you worked with SQL Server a longtime,
can you tell us a little bit more about
the history of SQL Server and Azure SQL and performance?
>> Yeah. Sure Anna. Performance is one of
those interesting areas of SQL Server and Azure SQL.
This is the second in our series of the meat and potatoes.
Remember, security was that
first thing and performance was the second.
Not necessarily in a different order or the same order,
or order doesn't necessarily matter is
just an important part of meat and potatoes and
then our third one is going to be availability in the next module.
But performance has some interesting characteristics
I've seen in my career at Microsoft and that is,
performance is usually hard to get
right and it's hard to keep right,
and to just make sure you're always
staying on top of performance for your application.
SQL Server over the years have provided
so many great functionalities to help you do all of those things,
but also performance has
this interesting characteristic about problems.
No one defines a performance problem very specifically.
It's usually very vague like it's slow or I don't know
how fast it is or it's changed in speed.
I think it's going to be interesting as
we look to this module about the topics we
built for you to understand in Azure SQL just like SQL Server,
what are the capabilities?
What tasks you need to do? How do you configure it?
How to maintain it? How do you monitor it?
Then what are those scenarios,
everybody likes to think of things in terms
of scenarios and we'll certainly do that in
this module and talk about what are
the key performance scenarios for
Azure SQL that feel like a little about SQL Server.
Then what I really love is we're going to go
bigger at the end of the module and talk
about how can you do things that are really neat in
the Cloud to help you tune that performance,
accelerate it, and then even some
really cool intelligent performance capabilities.
>> When we look at performance,
Bob, what really stands out to you?
>> Well, if you look at the slide right here we built again,
like security we're going to talk about
the capabilities of performance for Azure SQL,
and then what are the common task you need to do to configure and
maintain and keep performance
well for your application and database.
But just look at this list on the left.
These are things you struggled with and you deal with
SQL Server and it's the same thing
you're going to be dealing with Azure SQL.
A lot of times it's exactly the same and sometimes slightly
different because you're using the Cloud
and we're going to get into all those things.
But look at the tasks.
Those are the same things you're always
doing with a SQL Server deployment,
and it's really cool because we're going to show you,
really get into the details of
what is the same, what is different,
and then even where does the Cloud give you
some more capabilities or even save you
some time that you're not used to.
Anna, let me dive into some of
these capabilities and compare them from a SQL perspective.
First of all, when you just think about capacities,
when you're deploying SQL Server you care.
I'd have to think about CPU,
memory, how big my database is,
and we did in our early modules,
we talked about the different options you get
for those capacities and limits.
But consider a couple of things here,
like Azure SQL database if you didn't think it was possible,
you can go deploy an Azure SQL database
and get it to a 128 vCores,
four terabytes of memory,
and four terabytes of database space.
That's going to meet a lot of demands for the performance
needs of many different SQL deployments out there today.
You need something bigger than eight terabytes which you
can get actually in one of our deployment options.
Here's your choice, it's hyperscale.
Hyperscale is going to support a maximum of
a 100 terabytes and unlimited transaction log space.
You really need a big deployment database size
wise hyperscale is going to give that to you.
Within that managed instance,
you are going to get
a SQL Server Instance capability but
with these type sizes I'm showing on the screen here.
Just getting the right capacities,
early on we talked about pre-deployment,
we talked about your options during
deployment are going to be important.
But even as we showed you during deployment
and configuration in a previous module,
you can change some of this.
If you don't get it quite right,
maybe you need to scale up or down what you're doing.
We do have options for you to do that as well.
To think about indexes,
we support everything you need for indexes.
Everything you do in SQL Server
today for indexes we're going to be there for you,
and in case, in almost every tier we have,
we have things like column store indexes available to you.
Now in-memory OLTP has been a functionality
we've shipped for several releases of SQL Server.
It's for those really high speed,
low latency transaction environments,
and that is available in our business critical tier offerings.
We even going to pre-create a memory optimized file group for you,
and we're going to give you limits on
how much memory you're going to get as part of
your overall memory limit for
what we call hackathon memory in SQL Server.
You just look at these capabilities right here,
it's gliding up very much how you do things in SQL Server,
tailored to how you're going to configure and deploy in the Cloud.
Partitions are something that's been used for a lot of
different years for SQL Server applications
to take large tables and partition
them to maximize performance and manageability.
You do get partitioned capabilities.
A lot of people I've read out there say you don't get
that with Azure but you do get that with Azure.
The difference is you're not going to be placing file groups with
partitions in Azure database but you can
do that in a managed instance environment.
Then maybe a lot of you've
seen me over the last few years talking about
SQL 19 performance enhancements like intelligent query processing.
A lot of that functionality is there in Azure SQL,
not every single thing we've done in 19,
we're slowly and surely getting those capabilities into the Cloud.
But things like intelligent query processing
are available to you in Azure SQL in fact,
that's an example of something that started
in Azure first and then came down to SQL Server.
If I think about all these things together,
we've got the capabilities I think you
need to deploy SQL Server in the Cloud
and in several different cases it's going to be tailored
specifically to how you would use the Cloud.
>> Thanks Bob. It's really interesting to see some of
the capabilities that are both
in SQL Server and have made it to
Azure SQL as well as the other way around.
In the next videos, we'll dive deeper into how these tasks
relate to some of the capabilities. See you in the next video.