- 3 minutes to read

Managing Azure SQL Database Size Checks

Gain full control over your Azure SQL Database storage and performance with Nodinite's advanced size monitoring. This feature empowers you to:

  • ✅ Instantly detect when Azure SQL Databases exceed defined size thresholds
  • ✅ Automate alerts for oversized or unavailable databases
  • ✅ Perform remote actions directly from Nodinite
  • ✅ Ensure compliance and optimize storage for cost savings
  • ✅ Visualize and manage all monitored Azure SQL Databases in a single dashboard

The Size Check Monitoring feature helps you get alerts when the size of your Azure SQL Databases grows out of your control and/or the database is not operational.

The [Database Monitoring Agent][] actively monitors the size of your configured Azure SQL Databases. In Nodinite, each database appears as a unique [Resource][Resources], providing real-time state evaluation. You can monitor size status using [Monitor Views][] and trigger external alerts through any installed [Alarm Plugins][].

The main difference compared to SQL Server [SQL Size Checks][SQL Size Checks] is that there is no transaction log to monitor for Azure SQL Databases.

Size checks for Azure SQL Databases are grouped by the [Category][Categories] Azure - SQL Size Checks
![Category Azure - SQL Size Checks][4]
Here's an example of a Monitor View filtered by the 'Azure - SQL Size Checks' category.

  • Your Azure - SQL Size Checks within the Azure SQL database(s) are listed in Nodinite as [resources][Resources], where the name of the Azure SQL Database becomes the [Resource][Resources] name.
graph LR subgraph "Configuration" c["fal:fa-code 1 Azure SQL Database"] --> r[fal:fa-lightbulb 1 Resource] end

This diagram illustrates how each Azure SQL Database is mapped to a monitored Resource in Nodinite for size tracking.

What are the key features for Monitoring Azure Database Size Checks?

  • State Evaluation – Instantly monitors and evaluates the size of each Azure SQL Database
  • Remote Actions – Execute [Remote Actions][] such as threshold edits directly from Nodinite
  • Automated Alerts – Receive notifications for oversized or unavailable databases
  • Customizable Thresholds – Set global or specific size thresholds for warnings and errors
  • Centralized Visibility – View all database sizes in a single dashboard for rapid response

What is evaluated for Azure SQL Database Size Checks?

The different possible evaluated states for your Azure SQL Database are provided in the table below:

State Status Description Actions
Unavailable Resource not available Evaluation of the 'Database size' is not possible due to:
  • Network or security-related problems
  • A specific configuration exists with a database that no longer exists
 Review [prerequisites][Prerequisites for Database Monitoring Agent]
Error Error state raised The database size is above the error threshold value Edit
Warning Warning state raised The database size is above the warning threshold value Edit
OK Online Database size is within defined thresholds Edit

Tip

The System Administrator can override the Monitoring state using the Expected State feature on the [Resource][Resources] within Nodinite.