(SQL) Tip of the Day: SQL Azure Resource Usage

Today’s (SQL) Tip…

Today we will go over how you can see the resources your database is using on SQL Azure. The query below will allow you to view the amount of CPU, IOPS (i/o per second), memory, sessions, and workers you are using. If you are using near 1 core or near 150 IOPS you should seriously consider a Premium Database. You will need to run this query against you Master DB and change the database_name to your database’s name.


Comments (0)

Skip to main content