• Spotlight Instance Registration - Import From a File

    For environments that have lots of instances to be monitored, registering each of them one by one can be a bit time-consuming.

    A time-saving alternative is to import your instance list from a file.

    Step 1:

    Right-click on the SQL Server node in the navigation…

  • Postgres v. 14 has been released and it is SCARY good!

    Postgres v. 14 snuck up on us and was released about a month ago.

    The community continues to kill it with advancements in innovation.

    Have a look at these frighteningly powerful enhancements and additions.

    JSON:

      

    PostgreSQL 14 now supports the syntax…

  • Can Foglight Integrate with ‘X’? Probably…

    One of the most common questions I am asked when speaking with evaluators of Foglight is, “Can Foglight integrate with <insert solution here>? …Remedy, ServiceNow, SCOM, Splunk, Teams... The list goes on and on. This inquiry really comes as no…

  • Monitor Azure SQL Database with Foglight!

    (Click images to enlarge.)

    The conversation continues...

    Jim: " Tell me more! "

    Kim: " Foglight is Quest's award-winning cross-DBMS platform monitoring and diagnostics solution. Think of Foglight as a monitoring platform. It uses what they…

  • 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 customizable timeframes. In doing so, it may allow for…

  • 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. 

    Items to consider include:

    • All-in-one or Specialized…
  • 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…

  • 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 enlarge)

    What is SQL Optimizer?

    Caution…

  • (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…
  • 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 what? It’s a weekday morning and business…

  • 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…

  • Identify Long Running Queries with Foglight

    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 giving a nod to long runners,…

  • 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…

  • Monitor Postgres Disk Space Usage with Foglight

    Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninterrupted. Quest’s Foglight provides peace of mind by…

  • Comparing The Compare - Quest Foglight and Toad

    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 one is ‘better’. Other times, it is to determine those…

  • Expand your SQL Server monitoring coverage to include your BI stack with Foglight (3-Part Series) Part 3 – SQL Server Analysis Services (SSAS)

    Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

    In this (Part 3) blog, the focus is SQL Server Analysis Services or ‘SSAS’.…

  • Don’t Worry About Your (Con)figure, Have The PI !

    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 environment. Help yourself to delicious servings of baseline…

  • Tune Your Queries with SQL Optimizer (Pt 1)

    One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:

    1. Minimize Response Time – End users who are interacting with data want that data as quickly as possible. It may…
  • “License and Registration, please…” Spotlight

    So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It simply expires after the 30 days. There are a couple…