How can we help you today? How can we help you today?

SQL Dependency Tracker Hangs On VERY large SQL databases - 64bit or command line execution options?

I'm currently working with a VERY large SQL database (20k+ objects) and SQL Dependency Tracker hangs if I select the entire database at the "Add Objects to Project" modal. 1 out of 4 times it will continue on and eventually render the "death star" of dependencies. Sadly, when it does render I get an error of "Exception of type 'System.OutOfMemoryException' was thrown." when I try to save the project.

I'm wondering if there is a 64 bit distribution or beta build of Dependency Tracker?

Also, I looked through the documentation in hopes of being able to just run the exe with a few arguments to spit out a project file but didn't see anything. The exe doesn't appear to take any command-line arguments.

Any advice on trying to wrangle the death star?
Tanner Watson
0

Comments

1 comment

Sort by
  • DustinM
    Hi Tanner,
     
    Thank you for your inquiry into SQL Dependency Tracker. Unfortunately it looks like there are currently no plans to produce a 64 bit version of this offering.
     
    A potential workaround is to use Large Address Aware utility which will enable Redgate.DependencyViewer.UI.exe Large Address Aware (allowing this process to use up to 4GB RAM within a 64bit system). The following link will provide further information and the utility to download - https://www.techpowerup.com/forums/threads/large-address-aware.112556/
     
     
    Best,
     
    Dustin 
    DustinM
    0

Add comment

Please sign in to leave a comment.