Database Volume Testing Here are notes on how to create databases for Database Volume Testing using the AdventureWorks or other sample databases. Included is an analysis of tools, metrics, and procedures. Related Topics: AdventureWorks Benchmark Apps Oracle Architecture Oracle Tuning DB Management Data Warehousing SQL Coding Compared Data Types Compared Free Training! Tech Support

Topics this page: Overview Getting Data Values Tools Creating Stress DBs Your comments???

Site Map   About this site   Enter your search terms Submit search form Web   WilsonMar.com

Overview

Where To Get Data Values

The spreadsheet is used to specify how to create databases for data volume testing and transaction specifications for stress testing.

Data values are obtained from several sources:

• Territory/State codes and Zip/Postal Codes for the
  US, Canada, UK, and other countries
• Telephone area codes associated with Territory/State codes in the
  US, Canada, UK, and other countries
• Potential First and Last Names (by Gender and Nationality).
• Potential Street Addressses (if variation in this field length is desired)

Data Generation Tools

Red Gate SQL Generator

Quest

Quest

Creating Stress Data Volume DBs

Share

Next

Search for word: in this site in all googled sites in Whatis.com in Wikipedia in Technorati blog posts in Amazon.com in Crosswalk.com International Software... Globalization Java Internationalization Internationalization Localization Text Translation Locales with XML Languages Countries Currencies Unicode Entity Codes System Integration... IP Routing & Switching ISO-OSI Layers Routing & Switching Why I love my web hosting provider (Cooperative Systems)

Performance and Capacity Management... Performance and Capacity Planning Load Test Project Planning Load Test Project Reporting Load Testing Products Impediments and Mitigation of Performance Testing LoadRunner Scripting Script Generation From Spreadsheet Performance Monitors LoadRunner Reports LoadRunner Results Explorer LoadRunner Error Listings Performance Tuning Virtual Table Server Load Balancing Servers Mercury Capacity Planning Mercury Diagnostics

Syndicate this list of links:

Your rating of this page: Low High Your comments and suggestions, please: Publish this comment publicly

Your first name: Your family name: Your location (city, country): Your Email address:  Email updates (subscribe)

Top of Page Human verify:   Please retype:

Visitor comments are owned by the poster. Our Privacy Policy
All trademarks and copyrights on this page are owned by their respective owners.
The rest ©Copyright 1996-2011 Wilson Mar. All rights reserved.
Last updated | HTMLHELP | W3C XHTML | CSS | Cynthia 508