SIMULATION You need to increase the maximum storage size of the query store on db1 to 4,000 MB. You may need to use SQL Server Management Studio and the Azure portal. Answer: How to increase the…

Submitted by paula_co· Mar 6, 2026Implement and Monitor Database Infrastructure - specifically configuring and managing Query Store settings to support query performance monitoring and optimization in Azure SQL Database environments.

Question

SIMULATION You need to increase the maximum storage size of the query store on db1 to 4,000 MB. You may need to use SQL Server Management Studio and the Azure portal. Answer: How to increase the maximum storage size of the query store for an azure database using Azure portal? How to increase the maximum storage size of the query store for an azure database using SQL Server Management Studio? To increase the size of Azure Query Store, you can use Transact-SQL within either SSMS (SQL Server Management Studio or the Azure portal. Specifically, you'll need to modify the MAX_STORAGE_SIZE_MB setting for the database. No GUI options exist for direct modification within the Azure portal. Step 1: Connect to your database: Use SSMS or the Azure portal to connect to the database where you want to increase the Query Store size. [Connect to db1] Step 2: . Execute the ALTER DATABASE statement: Run the following Transact-SQL query (replacing YourDB with your database name and 1024 with the desired storage size in MB): ALTER DATABASE [YourDB] SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 1024); *-> Use the following query: ALTER DATABASE db1 SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 4000); Step 3: Apply changes: The Query Store will automatically adjust to the new size. Reference: https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance- by-using-the-query-store

Explanation

The correct approach is to execute 'ALTER DATABASE db1 SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 4000);' via Transact-SQL in either SSMS or the Azure portal Query Editor, as this is the only supported method to modify Query Store configuration settings. The MAX_STORAGE_SIZE_MB parameter directly controls the maximum disk space allocated to the Query Store, and setting it to 4000 satisfies the 4,000 MB requirement. There is no graphical (GUI) interface in the Azure portal that allows direct modification of Query Store storage size - T-SQL is the required mechanism for both on-premises SQL Server and Azure SQL Database.

Topics

#Query Store#Azure SQL Database#ALTER DATABASE#Performance Monitoring

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice