For over two decades, as a Database Sales Engineer, I have provided technical demonstrations either in-person, online, or in a recorded format. It takes a particular honed skillset to accurately disti...
( * This blog has been updated from last year's.... ) We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics. “Excuse me whi...
When you setup monitoring for SQL Server or Oracle, the checkbox to enable SQL PI is off initially. Here's what to do to enable it after setting up a monitoring connection. From the Databases dashboar...
To compare is to measure, estimate, or make note of two or more “ things’ “ similarities and/or differences. It helps us better understand the items. A versus B. Sometimes it is done to learn which on...
Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical en...
“The Only Thing That Is Constant Is Change “- Heraclitus. Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced ...
My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use. So if ...
We've all been there, the dreaded ticket that comes across our inbox. Always light on detail, just a single sentence: "The database server is slow." No five words bring as much fear, uncertainty and...
As a Sales Engineer for the Database Performance Monitoring team, one of the more rewarding aspects of my role is to learn about specific ways that our customers are leveraging Quest solutions. With t...
A colleague of mine (Darren Mallette) wrote a great blog post explaining how to query the embedded Foglight Performance Investigator (PI) repository using tools which provide native PostgreSQL connect...
So you've now taken a look at the architectural differences and enhancements between Performance Analysis and Performance Investigator (if you haven't, check them out here). You've also hopefully bee...
