GEM Automation – SQL Server Goodies!

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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s