When running the Batch Optimizer and selecting the option 'Add Objects by Users', SQL Optimizer hangs. After some time the program is reported as 'Not Responding'.
This is caused due to the amount of Users in the database, and the amount of objects assigned to each User.
SQL Optimizer is actually loading all the Users and related objects during this time, which looks like the application hangs, although it is still working in the background.
Allow some time for the process to complete. This amount of time will vary depending on the size of the database and the number of Users within it.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center