Testing Database Performance
September 5th, 2008 11:08 am
Query performance is one of the most difficult things to measure in a data warehouse, not least because of the ad hoc nature of the queries that will be run. There will probably be a set of fixed queries that have to be run regularly, and they should be tested. To measure the ad hoc queries, the best that can be done is to use the documented user requirements along with knowledge of the business to generate some queries that are meaningful to the business, and test those.
