What are the Crappy Code Games - What are the challenges?

This is part of a series on the Crappy Code Games  

  1. The background
  2. Who can enter?
  3. What are the challenges?
  4. What are the prizes?
  5. Why should I attend?
  6. Tips on how to win    

What are the challenges?

There are 4 games that you can enter. Each one is to test a different aspect of SQL Server.

  • The High Jump: Generate the highest I/O per second
  • The 100 m dash: Cumulative highest number of I/O’s in 60 seconds
  • The SSIS-athon: Load one billion row fact table in the shortest time
  • The Marathon: Generate the highest MB per second in 60 seconds

The system that you will be running your code against will have Fusion IO storage, obviously. This means that the normal rules for storage don’t apply. If you look at the specs for the IODrive http://www.fusionio.com/products/iodrive you will see that it can achieve ~ 750MB/s and ~120,000 IOPS. That’s shed loads more than spinning disks (you’d need 1200 disks to get that amount of IOPS)

For tips on Tips on how to win

The High Jump: The highest IO rate

Contestants are required to run their own TSQL queries to generate the highest peak ‘read’ load they can over a testing period of 1 minute to win. 

The Pages/sec performance monitor counter will be used to measure the number of pages that have been read in a second.

The 100 m dash: The highest total IO throughput measured in pages read over 1 min

Contestants are required to run their own TSQL queries to generate the highest total ‘read’ load they can over a testing period of 1 minute to win. 

The Pages/sec performance monitor counter will be used to measure the pages that have been read.

The SSIS-athon: The highest transaction rate measured in Write Transactions over 1 min

Contestants are required to run their own TSQL queries to generate the highest total  ‘Write Transactions‘ load they can over a testing period of 1 minute to win.  The highest Total Write Transactions in 1 minute figure returned by the script below wins. A transaction must involve changes to - at Least – two data tables in the AdventureWorks2008R2 databases related by one or more foreign key constraint(s).  A transaction must result in at least one record being added to a table, so there is a net increase in the number of records in that table at the end of the transaction.

The performance monitor counter 'Write Transactions/sec' will be used to measure this

The Marathon: Load one billion row fact table in the shortest time

The Fact Table to inflate must be the FactInternetSales table in the AdventureWorksDW2008R2.  Referential integrity must be maintained with all associated dimension tables and foreign keys need to be in an enabled and checked state at the end of the test.  Contestants may use any data embedded in TSQL statements and/or reference data already contained, in or derived from, FactInternetSales or associated dimension tables– no other data is to be used.

You can find the details of the events and Terms and Conditions here


  1. The background
  2. Who can enter?
  3. What are the challenges?
  4. What are the prizes?
  5. Why should I attend?
  6. Tips on how to win

You can find the details of the events and Terms and Conditions here

To register/enter the games go to http://www.crappycodegames.com/enterCompetition.php

Published Friday, February 11, 2011 9:37 AM by simonsabin

Comments

# What are the Crappy Code Games - What are the challenges? - Simons SQL Blog

Pingback from  What are the Crappy Code Games - What are the challenges? - Simons SQL Blog

# Twitter Trackbacks for What are the Crappy Code Games - What are the challenges? - Simons SQL Blog [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 What are the Crappy Code Games - What are the challenges? - Simons SQL Blog         [sqlblogcasts.com]        on Topsy.com

Friday, February 11, 2011 10:12 AM by SimonS Blog on SQL Server Stuff

# What are the Crappy Code Games - What are the challenges?

This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges