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

TannerWatson

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?

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