Administration

June Release of VerticaKit

0

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

  • Adds 1 queries
  • Added Projection Specific section & realigned queries

Download

This and all future releases are available through GitHub.

Release Information

This release contains 33 queries over 5 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 (13)
    • Distribution of Query Request Times
    • Proactively Examining Query Events
    • Overview of Query Event Types
    • Spill to Disk Events
    • Resegmented Query Events
    • 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
    • Mergeout Activity
  • Projection Specific (5)
    • Outdated Column Statistics
    • Columns Requiring Statistics Updates
    • Data Skew in Segmented Projections
    • Outdated and Un-refreshed Projections
    • 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.

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: