During a delivery of Advanced SSIS Training (by Tim Mitchell and Andy Leonard), Michael Smith suggested an idea for a site where SSIS performance benchmarks could be created and recorded. Thus, SSISPerformance.com was born. I was so struck by the idea; I purchased the domain while Tim was delivering a couple modules on Advanced SSIS!
The site is designed by an engineer for engineers. The idea? Create repeatable tests that can be executed by data integration developers who use SSIS (SQL Server Integration Services) along with a site to store and present results for comparison.
I created a test SSIS project that loads National Provider Identification (NPI) data known as National Plan and Provider Enumeration System (NPPES). NPPES is collected and maintained by the US Centers for Medicare and Medicaid Services (CMS) and is a list of US healthcare providers. How can you use this?
You can find the test procedure here. It includes links to the source data and the SSIS project named NPIData. The test project contains an SSIS package that creates a database and the two tables required for testing purposes. Instructions are included in the test procedure. Please let me know if you have any questions.
You can view my test conditions and results here.
I welcome your feedback.
:{>
Comments