In the middle of the week, when no particular significant activity is occurring against your data warehouse, you begin to receive sporadic reports of poor performance being experienced by users querying the data store. You schedule an emergency conference call with the various technical infrastructure groups (network, operating system, middleware, DBAs, security, shared storage, etc.) to try to identify the issue. The technical groups report no faults or obvious resource issues in the infrastructure. Meanwhile, news from the user community now shows that reporting and ad hoc query performance has appeared to return to normal. Your data warehouse performance issue has disappeared as fast as it appeared. How would you proceed from here?

This column is the second portion of a two-part series examining various data and infrastructure issues that may affect performance in the data warehouse environment. (See Part 1 at www.dmreview.com/article_sub.cfm?articleId=1014664.) In this installment, we will look at various infrastructure issues that can affect overall data warehouse performance plus some methods for detecting and measuring these factors.

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