It should be no surprise to you at this point, given the energy that I already expended on my soap-box about the need to monitor, that I will not be harping on performance monitoring in this section of the book as well. Understanding your overall performance is a very important part of running a data warehouse, regardless of the location of the data. Redshift has made quite a number of tools available to help you understand what is going on in the overall cluster as well as the very specific details down to the individual query level. The best practice for monitoring is to make it a habit. You will have a much better understanding of what is a "good" performance and what is an "unusual" performance if you are diligent about your monitoring ...

Get Getting Started with Amazon Redshift now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.