SSMS Plugin that analyzes the database

Sanjiv

Hi,
It's been a couple of years that I used Red Gate. I remember there was a RedGate tool that was a SSMS plugin that did an analysis of the database and reported issues on table fields types, missing indexes on foreign keys and a bunch of other suggestions. I just can't locate this tool anymore.

Does anyone know which tool I'm referring to?

Thanks

bauerju

Hi Sanjiv

do you mean "Find Invalid Objects" ? -> You'll get it with an right click on the database and in the contextmenu click on "Find Invalid Objects".

Jürgen
  

Ben_P

HI@Sanjiv, Thank you for your post.

It sounds like you might be referring to SQL Prompts SQL Code Analysis function:

https://documentation.red-gate.com/sp/sql-code-analysis

Sanjiv

Ben_P said:

HI@Sanjiv, Thank you for your post.

It sounds like you might be referring to SQL Prompts SQL Code Analysis function:

https://documentation.red-gate.com/sp/sql-code-analysis

Hi @Ben_P,
It might have been this tool however the tool used to have an option to run all it's analyis on the entire database and come back with a list of recommendations. I don't see an option to run the analysis across the database. https://share.cleanshot.com/nnWLP1MP  It seems more like prompting for hints and suggestions as you trying SQL in the SQL Editor.

Any suggestions? For example which action can I take to scan the entire database and report on missing keys on Foreign Keys among other things?

Thanks,
Sanjiv

Sanjiv

aha, I see the option "Show List of Code Analysis Issues..." but it's disabled. Any idea why?

https://share.cleanshot.com/DqhL0jR7

Sanjiv

SQL Prompts SQL Code Analysis function seems to work only with SQL in an editor, it does not scan the entire database for issues like I mentioned. Really wish I was able to track down the tool I used for this.

Ben_P

SQL Prompt should be able to scan the entire DB for invalid objects as shown here:

https://documentation.red-gate.com/sp/sql-refactoring/refactoring-an-object-or-batch/finding-invalid-objects#:~:text=In the Object Explorer, right,script in the lower pane.

SanjivJ

Ben_P said:

SQL Prompt should be able to scan the entire DB for invalid objects as shown here:

https://documentation.red-gate.com/sp/sql-refactoring/refactoring-an-object-or-batch/finding-invalid-objects#:~:text=In the Object Explorer, right,script in the lower pane.

But missing keys on Foreign Keys is not returned in the Invalid Objects report.