Analyze It…Don’t Criticize It
One of the primary needs of those responsible for maintaining the health of database environments is to efficiently find poorly performing queries. Are there resource-intensive queries running? Are th...
Is it a Typical Situation? Compare Performance Values with Spotlight
Spotlight users sometimes ask if it offers baseline capabilities. Though Spotlight does not learn a baseline of workload activity, it does provide the ability to view particular metric values over cus...
Monitoring Strategy Considerations
IT Administrators need to keep an eye on Availability, Performance, and Storage of mission-critical environments. There are many things to consider as you develop a Monitoring and Diagnostics strategy...
Database Monitoring for Developers with Foglight
Traditionally, DBAs are the ones primarily tasked with maintaining high availability and peak performance of the database environment. Therefore, they assume the responsibility of evaluating Performan...
Welcome to the Jungle – Amazon Cloud Deployments Part 3 (3)
Hey look, an Amazon Cloud! To recap, Part 1 covers 'As A Service' (...aaS) options - https://www.quest.com/community/blogs/b/performance-monitoring/posts/are-your-database-implementations-becoming-a...
Hands-On, Heads-Up, Heads-Together
These are difficult times we are in now but we will persevere. Hopefully, you and your loved ones are staying safe and healthy. Most of us are anxious to get back to some sort of normalcy. But, for no...
Foglight Workflows to Identify and Address Tuning Candidates
Foglight can help identify SQL Tuning candidates? Yes! Foglight can tune the SQL? With seamless integration with Quest’s SQL Optimizer, yes! OK, let’s stick a fork in this.... (Click on images to enl...
Aaaaaazure! (Bless you.) Part 2 (3)
In the spirit of keeping my blogs light and fun (?), the title was an attempt at that. In these interesting times (COVID-19 pandemic) and the need to stay home, I have been doing my share of yard work...
Are Your Database Deployments Becoming a Bit CLOUDY? Part 1 (3) – AaS the World Turns
Cumulus, Stratus, Cirrus….no…not that THAT kind of CLOUDY. The increasing number of cloud options can be confusing. With that in mind, I thought I’d ‘clear the air’ and review some of the more popula...
A Review of Postgres version 12
Postgres version 12 is here. Did you miss its introduction like me? My excuse is the year-end holidays (what's yours?). Well, version 13 isn't planned for release until the fall, so there's plenty of...
(Another) Foglight Countdown!
( * 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...
The Object of My Affection – Litespeed’s Object Level Recovery
All is well. Megan is having a good day. She’s a SQLServer DBA and her environment is humming along. Then…. someone drops a critical table bringing efficient data retrieval to a screeching halt. Now w...