As a Senior Oracle DBA with decades of experience optimizing databases, I was initially skeptical about AI's ability to handle the nuanced art of SQL optimization. Two days and hundreds of automated t...
Back in May, Amit Parikh wrote about the four ways to transform your business in the ROI of proactive database observability. We're excited to share that the recent release of Foglight 8.0 is engineer...
If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight...
Part 2 of this series will show you how to tune the queries you found by using Workload Analysis (see Part 1). Additionally, we'll look at the different 'Context' dimensions to help you quickly focus...
Database performance issues are a major contributor to the application slowdowns which we all face every day. DBAs, developers and IT professionals have a daunting task of deciphering the large number...
Read this webcast recap and watch the replay to get insights to help you appreciate why query and index performance tuning gets so difficult on relational databases. According to Gary Jerep, Solutio...
April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today. Man, running for that long must be taxing. Taxing…..wait…what day is it again? So, as my way of ...
We’re excited to announce that with Spotlight version 12.3, the Plan Visualizer feature now includes several new enhancements. In my last blog, I covered the Plan Visualizer feature included in versio...
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find ...
A Picture is worth a thousand words! Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations. Addressing these bottlenecks can ultimatel...
In April of 2016, upon engaging with a customer, we learned that the DBA team for the hospital managed an environment of over 70 SQLServer instances and had trouble keeping up with the ‘fires’ and rea...
