The complexities and cross dependencies of today's IT infrastructures pose continuous challenges for maintaining acceptable and consistent performance in the data warehouse environment. Data warehouse processing activities (reports; analytics; extract, transform and load [ETL]; queries; etc.) that initially performed optimally may begin to degrade over time. The operational impact to the data warehouse environment may not be readily apparent due to the rate of change or the seemingly sporadic occurrence of the these types of issues. These changes in the environment can be caused by a variety of factors that are directly or indirectly associated with the warehouse.

This column is the first portion of a two-part series examining various data and infrastructure issues that may affect performance in the data warehouse environment. Techniques for measuring and/or detecting performance issues in the data warehouse environment will be examined in part two.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access