kyle Hailey
Setting up Always ON (SQL Server)
There is a great little docker setup that starts Always On (SQL Servers instance replication not to be confused with their article i.e....
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Apr 13, 20224 min
introducing network latency on Docker (SQL Server Always On testing)
I am testing out Always On replication on SQL Server with a cool docker setup that includes primary and secondary https://github.com/rafa...
73 views0 comments
kyle Hailey
Mar 25, 202211 min
MySQL : events_waits_current – who is waiting and who is on CPU
Anyone familiar with Oracle performance tuning knows about ASH , aka active session history. ASH saves a history of every session that is...
22 views0 comments
kyle Hailey
Mar 24, 202212 min
MySQL -> what to do with NESTING_EVENT_ID
How does one use NESTING_EVENT_ID? Below I’ve selected from events_waits_history_long for a single thread, but none of the ...
42 views0 comments
kyle Hailey
Mar 23, 20226 min
MySQL waits and CPU
Question: how do I know that one user is waiting for a lock and another user is burning CPU on MySQL? i.e. how can I create active...
463 views0 comments
kyle Hailey
Jul 13, 20211 min
Postgres performance gone south but nothing changed !
Postgres seems pretty cool as open source databases go. I’m finding a much greater affinity for Postgres than say MySQL. On the other...
398 views0 comments
kyle Hailey
Jun 19, 20202 min
Covering Indexes in Postgres
Covering indexes are where all the columns needed are in the index and, in theory, only the index needs to be accessed. This seemingly...
56 views0 comments
kyle Hailey
May 22, 20202 min
Granularity impact on visualization
The longer the timeline we show in the graph, either the more points we show or the larger granularity we use. For example if I show 1...
14 views0 comments
kyle Hailey
Mar 30, 202014 min
Where to add Index on Postgres
Summary Goal in this post is to layout a methodology that can be implemented to scan the explain plans and identify opportunities to...
42 views0 comments
kyle Hailey
Mar 24, 20205 min
Indexes on Joins for MySQL
MySQL is simpler than the Oracle example because MySQL only has Nested Loops and doesn’t have Hash Join. Here is the query, like on the...
5 views0 comments
kyle Hailey
Mar 23, 202011 min
Indexes for Joins on Oracle
Looking at ways to programmatically analyze explain plans to see if adding indexes would help. The analysis is straight forward for for...
19 views0 comments
kyle Hailey
Mar 2, 20204 min
Oracle Imp (import) to RDS
Had and old export dump file I wanted to import into RDS. I first tried to use S3 as a hosting site for the .dmp file and...
256 views0 comments
kyle Hailey
Jan 29, 20202 min
Index Advisor ? PostgreSQL, Oracle and SQL Server : yes , MySQL : no
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...
32 views0 comments
kyle Hailey
Jan 23, 20201 min
SQLcmd on my Mac: Seg fault
trying to connect to SQL Server from my Mac so install sqlcmd: brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mss...
8 views0 comments
kyle Hailey
Jan 22, 20207 min
MySQL – manually updating table and index optimizer statistics
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...
5 views0 comments
kyle Hailey
Apr 26, 201961 min
Oracle: compare DB Time and CPU time to ASH
Good reference on subject: https://blog.orapub.com/20150210/what-is-light-green-oracle-database-cpu-wait-time.html Below I’m comparing...
793 views0 comments
kyle Hailey
Apr 10, 20191 min
Want to change the future Amazon RDS performance monitoring?
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...
16 views0 comments
kyle Hailey
Apr 3, 20193 min
Honeycomb.io for DB Load and Active Sessions
Honeycomb.io turns out to be a nice solution for collecting, retrieving and displaying multi-dimensional time series data, i.e. the kind...
47 views0 comments
kyle Hailey
Mar 28, 20195 min
Amazon RDS cluster dashboard with Performance Insights
Amazon RDS Performance Insights (PI) doesn’t have a single pane of glass dashboard for clusters, yet. Currently PI has a dashboard that...
15 views0 comments
kyle Hailey
Jan 11, 20191 min
“delayed commit ok initiated” – Aurora MySQL
“delayed commit ok initiated” – is a thread state in Aurora MySQL which indicates the thread has started the async commit process but is...
423 views0 comments
bottom of page