Later versions will be .NET 3.0 or higher
SQL Exec Stats, .NET Framework 2.0
Build 2010-09-01 One more try at Missing Index string parse.
Build 2010-08-31 Bug fix, Missing Indexes - string parse to number with format info.
Build 2010-06-21 Minor stuff, will document later.
Build 2010-05-30 Console mode, run with -c all parameters in config file must be correct.
Build 2010-04-13 Interim build, With interim documentation.
Many try-catch blocks disabled so errors are not unexpected.
Older versions have been removed.
Send me an email if older versions are desired for some reason.
Some new columns were added to the ShowPlans tab. I will document the changes later. The next version will move the StatementOptmLevel and StmtOptmEarlyAbortReason from the ShowPlan tab to the ExecStats tab. This data structure change will mean that the new version will not work with data files form earlier versions.
SQL Clone
Build 2010-03-04
This is an interim update for scripting Roles. A more thorough update is due, when I get a chance.
SQL System Build 2008-10-29
Trace Analysis Build 2009-01-11
This is my standard Profiler Trace script. Be careful in collecting execution plan information, as this could have high overhead.
Additional SQL scripts:
Current Running Query