I am going to run a very heavy script against my test database for testing new network storage. Can some one suggest what kind of scripts I can run.
The purpose is to create a lot of read/write to test database and shutdown to test our new DELL SAN storage. SAN was used for production DB, but since we have san installed, everytime when issue shutdown command, the controller will become I/O error- We just re-config SAN, and hope we can hit test DB very hard to see if SAN can take it or not.
Is it a good idea to run analyze tables (I have erp user who have 80,000 tables) to create heavy read/write?
TPC Benchmark C (TPC-C) is an OLTP workload. It is a mixture of read-only and update intensive transactions that
simulate the activities found in complex OLTP application environments. It does so by exercising a breadth of system
components associated with such environments, which are characterized by:
The simultaneous execution of multiple transaction types that span a breadth of complexity
On-line and deferred transaction execution modes
Multiple on-line terminal sessions
Moderate system and application execution time
Significant disk input/output
Transaction integrity (ACID properties)
Non-uniform distribution of data access through primary and secondary keys
Databases consisting of many tables with a wide variety of sizes, attributes, and relationships
Contention on data access and update