• Foglight for IT OPS – A Genie approach - Foglight EMAIL INTEGRATION (Part 1)

    We often get asked by customers how can they integrate Foglight with other products they own to streamline their daily operations. Based on my recent conversation with one of my customers and their IT Ops team, I had the opportunity to explore IT Ops tool…

  • Adding Email Notification to Database Alarms

    Foglight ships with a rich set of pre-configured rules to alert you when issues arise with your databases.

    The default action is to put an alarm message on the dashboards within Foglight. Email notifications aren't enabled by default - but it's an easy…

  • Using Alarm Templates in Foglight 6

    In this post, we looked at how to create an alarm template via the Databases dashboard.

    If you followed the steps outlined, you would've ended up in the Alarm Templates dashboard with a new template.

    You can also get to Alarm Templates directly from…

  • Introduction to Alarm Templates in Foglight 6

    With the release of Foglight version 6, alarm management has been simplified with the use of alarm templates.

    You can access Alarm Templates directly from the left-hand panel in the new UI. However, if you've upgraded from a previous version, it helps…

  • Exploring User Level Access for Databases

    I recently worked with a customer on the following use case. They've successfully integrated Active Directory logins with Foglight and wish to match up an AD Group with a group on the Databases dashboard in order to implement User Level Access (ULA).…

  • Series Finale - Automating Foglight Blackouts

    Way back in 2020, these posts formed the building blocks of using the command line to automate alarm blackouts in Foglight:

    Part 1

    Part 2

    Part 3 

    In Part 3, we looked at adding objects (instances, hosts, etc.) to a service definition, and then having the…

  • Tips for User-Defined Queries in Foglight - Part 3

    By now you may have noticed that I focus on parts of Foglight that you can easily customize in order to solve your specific use cases. We'll build on the previous post on User-Defined Collections (UDC's) in Foglight.

    In the previous post, our UDC…

  • Tips for User-Defined Queries in Foglight - Part 2

    In this post, some tips for working with User-Defined Queries (UDC's) were introduced.

    We left off with the idea of creating a custom dashboard showing UDC results from multiple instances.

    The Foglight data model is organized with a controlling root…

  • 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 now, for many of us, the situation has created the need…

  • Another Use Case for Database Groups

    On the Foglight for Databases main dashboard, you can create groupings of instances. These can be used to filter the dashboard, enable easier user-level access, and even allow fine tuning of alarms.

    These database groups can also be used in custom dashboards…

  • 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 time to brush up on v.12

    To give the nod…

  • (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 while I kiss this guy”. Correct lyric: “Excuse…
  • Can you believe this Administration?!

    What’s that you say? You think it may not be appropriate that a technology blog dive into politics?

    Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.

    Administration options are available…

  • We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 3 (of 3) – CRS and Exadata

    This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad and complete Foglight is as an Oracle monitoring solution…

  • We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 2 – ASM

    This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle.

    Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard.

    https://www.quest.com/community/quest/performance…

  • We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 1 – Data Guard

    Hold on, grammar and spelling enthusiasts. Already, you might be thinking, did he mean ‘Complementary’ or ‘Complimentary’? The answer? YES. This blog series focuses on additional Oracle monitoring capabilities beyond monitoring the Oracle instance…’complementary…

  • "These go to eleven"

    PostgreSQL has entered an exciting new chapter with the release of version 11 (10/18/18). This blog highlights some of the version 11 additions and improvements to PostgreSQL.

    ** The information shared in this blog was largely gathered from the postgresql…

  • Monitoring and Managing Locks in Postgres with Foglight

    One of the most valuable capabilities of Postgres is its support for concurrent ACID transactions. ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These database transaction properties help verify data validity. It is important…

  • Find the Top Application Servers Loading up your Database

    A customer recently asked if there was a way to find the top application servers that were placing load on their database instances.

    With Foglight Performance Investigator, it is very easy.

    Start with the usual tasks - setting the time range and specifying…

  • Setting up Monitoring with Foglight for Databases

    Once Foglight for Databases or Foglight for SQL Server has been installed, you’ll need to tell it what to monitor. Since Foglight doesn’t use any agents installed on the monitored systems, all you have to do is provide Foglight a SQL and Windows account…

  • Setting up Foglight when SQL Server wants SSL

    Updated in March 2021 -

    You now only need to check the "Use SSL" box when setting up your SQL Server connections in Foglight. This option appeared in the 5.9.x line of releases.

    A customer recently had this error message when trying to monitor…

  • Using tokens for Foglight dashboard access

    Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step.

    In Foglight Server version 5.7.5.7, the user security option of an auth token was introduced. My colleague @Beam.Liu wrote an excellent blog on the…

  • The Juggling Act of Modern DBAs

    Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers.  

    Didn’t sign up to be a clown?

    Hey, I know. I didn’t, either. But, listen, sometimes…

  • Diagnosing Blocking and Deadlocks with Foglight for Databases

    Finding where and how things are getting locked up

    Aside from IO bottlenecks, locking-related problems are the pains most commonly mentioned in the demos that we here at Quest Software provide for customers seeking database management performance tools…