Steps/query to find the performance of Azure SQL Server Database

  • 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

  • What you're looking for can mostly be found in the portal: https://portal.azure.com. In there, you can find:

    • The over all DTU consumption of your database on the Overview tab and you can click on the graph to change what metrics you see
    • Index tuning and query performance metrics under the Query Performance Insight tab on your SQL Database.
    • All other things you can configure are in there as well spread among the other tabs
    Also, you can use a lot of the DMVs that you have access to with on-premise SQL Server to help find any issues.

    There are a lot of ways to back up, but built into SQL Database is the Point-In-Time-Restore down to the millisecond. As far as I know, this is not configurable but is based on your performance level. You can get more information here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups

    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