Success is about Imagination

How does one check if there are missing indexes in a database? Is there a programatic way to do it? Explain Plan Most blogs on the...

trying to connect to SQL Server from my Mac so install sqlcmd: brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mss...

Goal was to create a empty table and poplulate it with optimizer table and index stats from a poplulated table to try and get the...

Good reference on subject: https://blog.orapub.com/20150210/what-is-light-green-oracle-database-cpu-wait-time.html Below I’m comparing...

UPDATE: All slots for this study have been filled. On the other and would love your feedback. Please send any ideas about what you’d like...

Honeycomb.io turns out to be a nice solution for collecting, retrieving and displaying multi-dimensional time series data, i.e. the kind...

Amazon RDS Performance Insights (PI) doesn’t have a single pane of glass dashboard for clusters, yet. Currently PI has a dashboard that...

“delayed commit ok initiated” –  is a thread state in Aurora MySQL which indicates the thread has started the async commit process but is...

Installing CLI on LINUX 1. install PIP https://docs.aws.amazon.com/cli/latest/userguide/awscli-install-linux.html#awscli-install-linux-pi...

Thanks to Jeremiah Wilton for the following info: This wait event indicates that there is a thread which is waiting on an InnoDB record...

If you think so, check out shell script “ioh.sh” from github at  https://github.com/khailey/ioh Introduction and Goals The goal of ioh.sh...

I always forget IP address range coverage rules and forget where to look. It’s the wiki! https://en.wikipedia.org/wiki/Classless_Inter-Do...

How do you determine if the Oracle SQL optimizer has created a sub-optimal execution plan? re-run statistics and see what happens? wait...

http://www.oaktable.net/blog/oak-table-world-2017-oracle-open-world The Oak Table members will be discussing their latest technical...

While at Delphix, we did a lot of storage benchmarking. The I/O response times of Delphix depends, as one would logically imagine,...

photo by Thomas Hawk https://github.com/khailey/pgmon $ ./pgmon.sh Usage: pgmon.sh [username] [password] [host] <sid=postgres>...

pgload.jmx is JMX file you can load into Jmeter and run a substantial load on a Postgres database. Should work just as well on Oracle if...

Little did I know this building that captured my visual attention and imagination so many times walking to work over the last 6 months...

So Jmeter seems super cool. I’ve only used it a little bit but it does seem a bit touchy about somethings (like spaces in input fields)...

This blog post is just a start at documenting some of my experiences with jmeter. As far as load testing tools go, jmeter looks the most...