HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Database Engine Tuning Advisor - The minimum storage space required exceeds the default

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
enginethespacetuningminimumstoragedatabasedefaultexceedsadvisor

Problem

I created a test database with one table

CREATE TABLE [dbo].[TestTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TimeStamp] [datetime] NOT NULL
) ON [PRIMARY]


I have a sql script that consist of one line.

INSERT INTO TestTable ([TimeStamp]) VALUES(CURRENT_TIMESTAMP);


When I run the script in SSMS it works. But when I use it as a workload in DTA the the Analysis is Aborted with this error


The minimum storage space required for the selected physical design
structures exceeds the default storage space selected by Database
Engine Tuning Advisor. Either keep fewer physical design structures,
or increase the default storage space to be larger than at least 3
MB.Use one of the following methods to increase storage space: (1) If
you are using the graphical user interface, enter the required value
for Define max. space for recommendations (MB) in the Advanced Options
of the Tuning Options tabbed page; (2) If you are using dta.exe,
specify the maximum space value for the -B argument; (3) If you are
using an XML input file, specify the maximum space value for the
element under

Using Windows 10 (latest update), SQL Server 2016 SP1.

Why do I get this error?

Solution

You have to go to Tuning Options and then Click Advanced Options. On the popup, define the max. space for recommendations.

https://www.sqlservercentral.com/Forums/Topic1383773-391-1.aspx

Context

StackExchange Database Administrators Q#155746, answer score: 3

Revisions (0)

No revisions yet.