Workload Failed in Database Engine Tuning Advisor
What to do when Consuming Workload Fails in Database Engine Tuning Advisor? You may face below errors during analysis so let’s solve these issues.
Error 1:
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 <StorageBoundInMB> element under
<TuningOptions>
Error 2:
The minimum storage space required for the existing physical design structures (PDS) you have selected to keep is larger than the storage space provided. Choose fewer PDS to keep, or set the storage space to be larger than 22 MBs.
Figure-1 is showing same error as above in GUI format.
Figure 1: Consuming Workload Failed
To solve this error through GUI kindly follow these steps as shown in Figure-2.
1. Go to Tuning Options
2. Tick mark ‘Define max. space for recommendations (MB)’
3. Assign memory, more than mentioned in the error so that Database Engine can easily process your workload.
4. Click OK and Start Analysis again. Issue resolved, it’s so simple.
Figure 2: Tuning Advisor Advanced Option
CLICK HERE to watch live practical.
Reference: Manzoor Siddiqui [www.SQLServerLog.com]
You may also like
