Monday, July 15, 2013

You may need to boost memory allocation in the Database Engine Tuning Advisor.

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 2 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>

...is an error one might see when trying to analyze a query in the "Database Engine Tuning Advisor" which is a thing that you may have as a part of your Microsoft SQL Server install. The cure:

  1. go to the "Tuning Options" tab
  2. click "Advanced Options..."
  3. check the checkbox by "Define max. space for recommendations (MB):"
  4. type some big number like 200 into the fill-in-the-blank box at the upper right of the "Advanced Tuning Options" dialog box
  5. click "OK"

1 comment: