DB digram, Standard reports to use.

• sizal0234

  SSCrazy

  Points: 2272

  More actions

  September 19, 2019 at 6:22 am

  #3681281

  Hi,

  Please let me know..

  1. DB Diagram: SSMS is not helping with so many tables and huge DB. Please advise if there are other ways which can be helpful to generate or create DB diagram. The goal is to understanding the tb lvl relationship and what is the MASTER table and get better understanding.

  2. I feel standard reports which are built in sql server are sometimes helpful. However is there any best practice of checking certain standard reports which are helpful.. ( Report - when you right click in ssms on DB or instance name and have report option ..example ..disk usage report. There are multiple reports available however I was wondering which are critical or imp for a DBA.

  Thank you!

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  September 19, 2019 at 1:05 pm

  #3681388

  I use redgate's sql dependency tracker (part of toolbelt)

  although you can use the sysdepends table (it's not accurate if you have dynamic sql or objects are built in the wrong order)

  MVDBA