March 20, 2018 at 1:49 am
Steps / query to find the below:
to find any index tuning required
find the backup policy and also any backup policy adjustments
find the performance recommendations
find all the metrics regarding the performance
find the general configuration adjustments
March 20, 2018 at 6:14 am
What you're looking for can mostly be found in the portal: https://portal.azure.com. In there, you can find:
I assume by "performance recommendations" you're referring to what pricing tier of the database is recommended. This may have changed, but when I started looking into this years ago, Microsoft recommended ballparking your first tier based on your current system's IO and CPU usage. If this is a high usage system that needs to be always on, I recommend estimating higher. After that, you can look at the performance you're currently using in the portal. If you're using less than half, then you can go down one level(ie, from S2 to S1). In general, each tier as you move up doubles the amount of available DTU.
I hope this helps you getting started on some of these.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply