Browse By Tags

  • FOGLIGHT SQL version 7.3

    how to avoid generating alerts that are generated when the databases are different from the online status, i.e. I do not want to be alerted when they are in recovery or any other state?

  • Why does Foglight kill SPIDS

    I noticed that SPIDS were being killed on a regular basis although the timing was Intermittent. There appears a record in the SQL Server errorlog which reads as follows: Process ID 121 was killed by hostname xxxxx-SPOTL-APP, host process ID 0.

    After some…

  • Announcing Quest®︎ Foglight®︎ Cloud General Availability!

    Embrace the Future: Foglight Cloud Now Available for Your IT Revolution

    We're thrilled to announce the general availability of Foglight Cloud, a transformative solution reshaping how organizations manage and monitor their IT environment. Foglight Cloud…

  • Announcing Quest®︎ Foglight®︎ v6.3 General Availability

    Background

    We are very excited to announce the general availability of Quest® Foglight® version 6.3.

    Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…

  • Uncover the Culprits: Identify Time-Consuming Queries with Foglight

    Query Insights: Coming soon in Foglight v6.3!

    As organizations rely more on data to make critical business decisions, ensuring that their databases are running efficiently becomes increasingly important. A database slowdown or crash can result in a significant…

  • User Defined Collection Not Showing Up

    Attempting to add a UDC on different SQL servers spanning different versions and the query itself will verify correctly, I have set the key and all the types but it still will not appear in the UDC Overview screen.

    The closest error I can find is:

    2021…

  • Not able to configure the SQL PI

    Hi All,

    I am new to foglight, while configuring I got below error,  can you please help me on resolve this issue.

    Failed to enable SQL PI monitoring extension for SQL Agent Test
    Failed to establish connection to SQL PI repository from the FMS. Connection…

  • Correlating VMware metrics with SQL Server Performance - in 2 Parts

    There are a couple easy, free ways to get VMware metrics collected by Foglight for SQL Server. This first part shows the easier way.

    When setting up the monitor for SQL Server, you can select (or not) to provide VMware credentials.

    Foglight will connect…

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

    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 1) blog, the focus is SQL Server Integration Services or ‘SSIS’…

  • Foglight for SQL Server: Back to Basics - Diagnosing Blocking

    I've done a number of posts recently that touch on Foglight administration, customization, or some of the more advanced capabilities of the product.  I felt it was a good time to circle back on some of the more basic use cases that Foglight can help…

  • DBSS - Long Running Job exception duration for single job

    Hello All,

    This alarm "DBSS - Long Running Job"  have a global fire threshold for all the jobs.

    I can see that there is an exception in order to exclude specific jobs.

    Does there is a way to make an exception for a single job duration that will…

  • Foglight for SQL Server Quick Tip - Database Exclusion

    If you are someone who is responsible for administering Foglight when used for monitoring SQL Server Instances, you will likely run into the situation where you want certain databases to be neglected from the overall monitoring.  There are going to be those…

  • SQL Grant permission script error

    Dear All, 

     

     We have recently upgraded the  Database cartridge to 5.7.5.35.  We are trying to configure a SQL 2012 DB, when we try to manually execute the Grant permission script  we are receiving the below error.

    msg 207, Level 16, state 1 line 27

    Invalid…

  • Foglight for Databases (SQL Server and Oracle): New Release - Version 5.7.5.35

    We are pleased to announce the general availability of Foglight for SQL Server and Foglight for Oracle versions 5.7.5.35.  This release provides the following significant enhancements:

    • Performance Investigator (PI) Advisories - Fully automated engine…
  • Foglight for SQL Server: Business Intelligence Monitoring - SQL Server Integration Services

    Microsoft has evolved their marketing over the past several years to focus on the fact that SQL Server is more than just a Relational Database Management System (RDBMS).  You may have noticed, that Microsoft commonly now refers to SQL Server as the SQL…