Administration

May Release of VerticaKit

2

The May 2014 release of the VerticaKit has the following changes:

  • Fixed schema for query_requests for query time distribution
  • Adds 6 queries
    • Nodes with less than recommended disk space available (40%)
    • Workload analyzer tuning rules
    • Tables without primary keys (help with optimizing joins)
    • Percentage of database that has been deleted
    • Denied resource requests (identify resource space and pool issues)
    • Projection last used timestamp (identify unused projections)

Download

This and all future releases are available through GitHub.

Release Information

This release contains 32 queries over 4 sections and covers the following:

  • Configuration Information (6)
    • Product Version
    • License and Compliance Status
    • Data Collector Status
    • Changed Configuration Parameters
    • Configuration Change History
    • Fault Tolerance
  • Resource Information (5)
    • Disk Space Utilization by Host
    • Processor Information by Host
    • Memory Information by Host
    • Compressed and Raw Estimate Data Space Usage by Schema
    • Disk Space Warning
  • Diagnostic Information (17)
    • Distribution of Query Request Times
    • Proactively Examining Query Events
    • Overview of Query Event Types
    • Spill to Disk Events
    • Resegmented Query Events
    • Data Skew in Segmented Projections
    • Outdated and Un-refreshed Projections
    • Outdated Column Statistics
    • Columns Requiring Statistics Updates
    • Load Events with Rejected Rows
    • Query Requests with Errors
    • Service Intervals and Last Run
    • Workload Analyzer Tuning Rules
    • Possible Missing Primary Keys
    • Deleted Database Date
    • Denied Resource Requests
    • Unused Projections
  • Query Profiling Information (4)
    • Profiling Configuration
    • Clearing Profile Data
    • Query, Session and EE Profiling
    • Examining Query Profiles

Feedback and any ideas for future releases is certainly appreciated.

About the author / 

Norbert Krupa

Norbert is the founder of vertica.tips and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

2 Comments

  1. Curtis May 19, 2014 at 1:06 PM -  Reply

    Great set of queries, Norbert. Here’s one you can add:

    • Norbert Krupa May 19, 2014 at 2:01 PM -  Reply

      Thanks, Curtis!

Leave a Reply

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.

Notice

This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: