Query performance monitoring

Now that you have some of your queries running, you may have built some of the queries that support your end user reporting or even connected your favorite reporting software. One of the challenges that most of us face in any data warehouse environment is "what is running?" When we looked at the implementation of workload management, we discussed the desire to provide a consistent query execution time. Inconsistent query performance, as you know, can be due to other running queries as much as it can be due to the query in question. The Redshift Management console provides quite a bit of good help in the query-monitoring department. Clearly, quite a bit of energy has been spent by Amazon to make query monitoring a seamless ...

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.