With the latest release of GEM Automation comes a few interesting goodies for the SQL Server DBAs out there.
Using some of the new functions, you will be able to generate reports with the following information:
– Estimated IO, CPU and rows manipulated for views and stored procedures
– Lines of code and usage of temporary tables, variables
– Missing indices/primary keys analysis
– Column references in stored procedures in views
– Table statistics and compression estimates
The code statistics is mostly done by generating estimated execution plans and parsing the resulting XML while the table statistics are gathered through sys.* objects.
Let me know if you have other ideas on how this could be improved!
You can find the new release here.