Link to home
Start Free TrialLog in
Avatar of delkent
delkentFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Error when running SQL DTA "The minimum storage space require for the existing physical design structures......"

When I run the SQL DTA against a set of queries that a report calls I get the attached message. It states that if I set the storage space to be larger than 72057594037946064 MB it will work.

User generated image
Obviously this is completely impractical and i can't see how this is anything other than a glitch in the software. I have set it to 128MB currently.

I have seen many people have encountered this error, but this is overcome by setting the value in the Tuning defaults. Obviously given the high value this will not be possible.

Thank you in advance for your help!!
ASKER CERTIFIED SOLUTION
Avatar of EvilPostIt
EvilPostIt
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial