This script file contains a sample benchmark that has the following:

 

• Two functions (one that retrieves transaction log metrics using SMO, another that does it directly through System.Data.SqlClient)
• A loop that loads an array with 5000 items, duplicating two distinct server names
• Benchmark testing agianst 5000 servers, while adding the cumulative times

 

Note:  This is sample code that isn't meant to be used in a production environment.  Nor does this imply that I'm recommending direct data access vs. SMO.  SMO allows the end user to not worry about direct SQL statements, and provides a handful of safeguards.  This code is merely meant to illustrate an optimization benchmark.