Testing Database Performance

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.

Leave Your Comment

Name*
Mail*
Website
Comment