hierarchic view...

Visualizes SQL Server object dependencies.

hierarchic view...

Postby randyv » Thu Mar 15, 2007 4:50 pm

Hello -

Just wondering what the upper object limit is for SQL DT2?

Here is why I ask - I'm in the middle of a data conversion project going from one ERP system to another.

In the new ERP system, I have a couple of databases that I want to load into the application and display using hierarchic layout.

Now, bear in mind these are commercial ERP databases (LOTs of tables, views, sprocs, etc.)

The baloon layout comes up after a few minute processing.

I save the project. Then I select hierarchic layout.

I'm on an IBM 3000 J Series Athlon X2. Running Windows 2K3 server.
(That's my PC running DT2). The last time I tried this was 2 days ago, left it running for over 48 hours, all that ever happened was the progress meter kept spinning indicating it was chugging on the layout... so I finally killed it.

Hence the question -


What we do in life echoes in eternity <><
Randy Volters
Posts: 113
Joined: Wed Feb 28, 2007 2:27 pm

Postby Dan J Archer » Fri Mar 16, 2007 11:33 am

Hi Randy,

There's no hard limit on Dependency Tracker, but as you've noticed some of the layouts perform significantly worse with substantial numbers of objects.

Version 2 has been tested with up to a couple of thousand objects, though not all layouts are performant at this point. On the other hand, 48 hours does seem very excessive. Was the CPU usage for Dependency Tracker still high at that point? I'm not certain, but this could be a bug in our layout algorithms.

I'm not sure if you can send us the data in question, but if so we may be able to try and diagnose the problem.

All the best,

Dan J Archer
Posts: 81
Joined: Mon Oct 10, 2005 10:15 am
Location: Red Gate Software

sending data...

Postby randyv » Fri Mar 16, 2007 12:08 pm

Dan -

Zipped file OK? Who do I send it to?
What we do in life echoes in eternity <><
Randy Volters
Posts: 113
Joined: Wed Feb 28, 2007 2:27 pm

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 1 guest