How We Tested: Benchmarking SQL Server

Our sister company, InfoWorld Consulting Services, ran the benchmark tests on SQL Server 7.0 using InfoWorld's enterprise database model. The database contained about 20G of data and 38 tables. The tests consisted of online transaction processing (OLTP) and Decision Support System (DSS) tasks. We tested at three workloads: light, moderate and heavy.

For OLTP, we used 30, 60 and 90 virtual clients to represent those workloads. The OLTP clients ran without think time. OLTP workload tasks mimic a real-world order entry system. For example, we looked up customer information, ordered items, adjusted inventory and paid a commission to a sales representative.

Our DSS workload consisted of nine queries, ranging from simple to complex. For example, our simplest query was a single table select with a "where" clause. Our most complex query joined multiple tables and included sorting and aggregates. We ran the DSS workload from four, eight and 12 clients to represent light, moderate and heavy workloads

Featured

  • Acquisition
    network monitoring (nmedia/Shutterstock.com)

    How companies should prep for CMMC

    Defense contractors should be getting ready for the Defense Department's impending cybersecurity standard expected to be released this month.

  • Workforce
    Volcanic Tablelands Calif BLM Bishop Field Office employee. April 28, 2010

    BLM begins move out of Washington

    The decision to relocate staff could disrupt key relationships with Congress and OMB and set the stage for a dismantling of the agency, say former employees.

Stay Connected

FCW INSIDER

Sign up for our newsletter.

I agree to this site's Privacy Policy.