PaaS database optimization

As we discussed previously in this chapter, PaaS databases offer a lot of features. The sets of features that are included can also be cost drivers, which can raise the cost if not looked at and planned for carefully.

In this section, we will provide some strategies that can be used in PaaS databases for cost optimization, as well as zooming in on some concepts that were covered in the previous chapter, such as scaling, but with the specific aim of databases.

Compute optimization and rightsizing

For database optimization, it is key to have a clear definition of the workloads, which should include the type of data to be processed (structured or unstructured), the solution (migration scenarios, for example), as well as user concurrency, high availability, and other key factors.

In this section, we are going to review different metrics that we can use to determine whether our databases are correctly sized, which begins by applying common sense when...