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

Posted on 2012-08-13
Last Modified: 2012-08-20
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.

DTA Error
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!!
Question by:delkent
    1 Comment
    LVL 16

    Accepted Solution

    Microsoft have a kb fix for this. Please see the below link.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now