patternsqlMinor
Database Engine Tuning Advisor - The minimum storage space required exceeds the default
Viewed 0 times
enginethespacetuningminimumstoragedatabasedefaultexceedsadvisor
Problem
I created a test database with one table
I have a sql script that consist of one line.
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?
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
https://www.sqlservercentral.com/Forums/Topic1383773-391-1.aspx
Context
StackExchange Database Administrators Q#155746, answer score: 3
Revisions (0)
No revisions yet.