What to do when Consuming Workload Fails in Database Engine Tuning Advisor?

  • Hi all,

    What to do when Consuming Workload Fails in Database Engine Tuning Advisor?

    The minimum storage space required for the existing physical design structure (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 33254748621487313548631 MBs

    I set max space for recommendation in tuning option, but not affect!

  • ramezani583 21209 (9/27/2015)


    Hi all,

    What to do when Consuming Workload Fails in Database Engine Tuning Advisor?

    The minimum storage space required for the existing physical design structure (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 33254748621487313548631 MBs

    I set max space for recommendation in tuning option, but not affect!

    I'm no fan of the DTA but something is definitely not right here, have you double checked the settings?

    😎

    In a perspective, storing 33254748621487313548631 MBs is roughly equivalent of storing 32 Gigabytes for every grain of sand on the Earth.

  • i check again setting, attachment file show error!!!

  • Quick question, are you trying to analyze everything on a large server in one go?

    😎

  • I experience to analyze in offline and small DBs,

    But this time I want analyze large DB.

  • You might want to carefully select the database and the tables to tune in the General Tab, start with few and add more, even in a different session.

    😎

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply