During my time working with Vertica, I created an essential kit that contains vital queries and resources for administering Vertica.
The diagnostic queries can be found on GitHub.
All My Vertica related material will be available through vertica.tips instead of continuing to cross-post.
I’ve been working on something similar, the Vertica SQL Toolbelt. On Git; diagnostic views.
Doug–I’ve come across your site (and git) and have found it helpful. My hope is to create a maintenance solution similar to what Ola Hallengren has for SQL Server. It’s going to take some time to get there as I’m still new to Vertica. It’s been a struggle to find useful information and I just want to share as much as I can along the way.
Thanks to both of you and I am newly looking at this. I will be checking on this blog as I move forward. Currently SQL server database engineer transitioning to vertica admin/developer. May see you at the coference next month?
Kim–I’ve moved most of the Vertica related materials over to vertica.tips. I will be attending the conference in August; hope to see you there.
Nice collection of information that otherwise would be unknown to the community.
The files within the kit and also within the related toolbelt from Doug appear to have copyright statements in some of the files but not all and there is no license statement easily located.
Are you able to add a LICENSE file to the kit so that readers can determine if their organizations will let them use it within their Vertica deployments ?
Thanks, Karl. I’ll definitely work on adding a license to my Vertica Kit. I’ll also ping Doug about having a license added to his toolbelt.